SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DDS(Detail Data Store) fro banking

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

SAS DDS(Detail Data Store) fro banking

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


Accepted Solutions
Solution
‎07-27-2015 11:03 AM
SAS Employee
Posts: 4

Re: SAS DDS(Detail Data Store) fro banking

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.

View solution in original post


All Replies
Super User
Posts: 5,260

Re: SAS DDS(Detail Data Store) fro banking

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

Data never sleeps
Occasional Contributor
Posts: 15

Re: SAS DDS(Detail Data Store) fro banking

Thank you

Solution
‎07-27-2015 11:03 AM
SAS Employee
Posts: 4

Re: SAS DDS(Detail Data Store) fro banking

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.

Occasional Contributor
Posts: 15

Re: SAS DDS(Detail Data Store) fro banking

Thank you so much, pic@sas Smiley Happy

This is the most appropriate & helpful solution i got.

I understood both roles.

Thank you so much.!


☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 969 views
  • 1 like
  • 3 in conversation