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 more
