BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
vishu
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
pic_sas
SAS Employee

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

4 REPLIES 4
LinusH
Tourmaline | Level 20

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

Data never sleeps
vishu
Fluorite | Level 6

Thank you

pic_sas
SAS Employee

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.

vishu
Fluorite | Level 6

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.!


sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

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