How do I load ETL to SAS Credit Scoring Foundation Mart from non-DDS?
I am trying to understand the libraries for Foundation Mart but it is still kinda new and unclear for me. In my past experience in non SAS CS project, I always create library for ETL to extract from source and load to target.
I am now assigned to load data to SAS Credit Scoring Foundation Mart using SAS non-DDS source. Transformation is done using SAS Data Integration Studio. Question is, are all foundation mart table created under "Products" logical folder?
I referred to SAS Credit Scoring 6.2 admin guide and there is no clear instruction for what library is Foundation Mart. Same goes to SAS CS jobs. There are jobs there but should I create a new job elsewhere for further transformation or should I just modify the default job there? Also, should i create foundation mart table that is already exist in the CS?
I understand that Dimension tables are all assigned to DIM library. Does it mean for any ETL job that i build, I will have to load the data back to this original table that was pre-built by SAS CS? for example: I have changes to DIM.APPLICATION_DIM and so I build a job in DI Studio for transformation. Once transformation is done, I have to flow back to DIM.APPLICATION_DIM? If yes, what about the pre-built Job as it has transformation by default?
I really hope SAS Community can help me or atleast advise me.
