topic Re: SAS DDS(Detail Data Store) fro banking in SAS Data Management

SAS DDS(Detail Data Store) fro banking

vishu — Sun, 26 Jul 2015 11:15:23 GMT

Hello,

I am new at sas DDS concept.

Can someone help me with what is the roles/responsibilities of SAS DI DEVELOPER IN SAS DDS FOR BANKING?

I know the basics of SAS DDS But still not able to figure out what & how sas DI developer will work with SAS DDS?

Thank you

Re: SAS DDS(Detail Data Store) fro banking

LinusH — Sun, 26 Jul 2015 20:35:19 GMT

Using DI Studio is preferred. Talk to your project /maintenance manager for your specific ser of roles and responsibilities.

Re: SAS DDS(Detail Data Store) fro banking

vishu — Mon, 27 Jul 2015 08:10:13 GMT

Thank you

Re: SAS DDS(Detail Data Store) fro banking

pic_sas — Mon, 27 Jul 2015 15:03:16 GMT

The question is likely too vague to answer precisely. The roles and responsibility of a DI Developer for B-DDS is diverse and depending upon the use of DDS it would vary.

E.g. if you want to load the DDS tables (e.g. Customer, Individual, Internal_org, etc.) then your responsibility would be

1. Identify the source tables/files for the DDS tables

2. define the mapping for each of the columns of the table

3. Decide the Historisation concept for the organisation and accordingly use the transformations

4. Also, decide along with the customer or business representative, the cleansing process

5. Finally, write the DI job(s) that would extract the data from source tables/files and transform them using the mapping that is done, apply the Data Cleansing and then Historise the data and load into the target DDS table.

However if your sources are the DDS tables and the goal is to load the Data Mart tables, then the responsibility would be

1. Identify the DDS tables which would act as Source for already designed data mart table

2. Define the mapping for each of the Data mart column for a table

3. As per the designed Surrogate key concept use the appropriate SAS DI Transformation to generate the Surrogate key

4. Finally write the DI Job which would extract the DDS tables and transform them using the mapping and load into the target Data Mart table using the appropriate table loader/transformation.

Hope this gives you some idea about DDS and DI Developers role in DDS.

Re: SAS DDS(Detail Data Store) fro banking

vishu — Fri, 31 Jul 2015 11:26:43 GMT

Thank you so much, pic@sas

This is the most appropriate & helpful solution i got.

I understood both roles.

Thank you so much.!