SAS - SAS® Certified Data Integration Developer for SAS®9

Curriculum

Module 1: Creating Metadata for Source and Target Data

• Define administrative tasks to be performed for SAS Data Integration Studio.
• Describe the New Library Wizard.
• Use Register Tables wizard to register source data.
• Register metadata for a comma-delimited external file.
• Import and Export Metadata.

Module 2: Creating Metadata for Target Data and Jobs

• Describe features of the New Table wizard.
• Discuss components of Join's Designer window Investigate mapping and propagation.
• Work with performance statistics.
• Generate reports on metadata for tables and jobs.
• Define Impact and Reverse Impact Analysis.
• Import SAS code.

Module 3: Working with Transformations

• Discuss and use the Extract and Summary Statistics transformation.
• Discuss and use the Loop transformations.
• Investigate where status handling is available.
• Explain the functionality of the Data Validation transformation.
• Discuss and use the Rank, Transpose, Append, List and Sort transformations.
• Discuss and use the Apply Lookup Standardization transformation.
• Discuss and use the Compare Tables transformation.
• Discuss and use transformations in the SQL grouping of transformations.
• Apply and use the Standardize with Definition transformation.

Module 4: Working with Tables and the Table Loader Transformation

• Discuss reasons to use the Table Loader transformation.
• Discuss various load styles provided by the Table Loader transformation.
• Discuss various types of keys and how to define in SAS Data Integration Studio.
• Discuss indexes and how to define in SAS Data Integration Studio.
• Discuss Table Loader options for keys and indexes.
• Discuss the Bulk Table Loader transformation.
• Discuss and use the components of the Join's Designer Window related to in-database processing.

Module 5: Working with Slowly Changing Dimensions

• List the functions of the SCD Type 2 transformation.
• Define business keys.
• Detect and track changes.
• Discuss the Lookup transformation.
• Discuss the SCD Type 1 Loader.

Module 6: Defining Generated Transformations

• Define SAS code transformation templates.
• Create a custom transformation

Module 7: Deploying Jobs

• Discuss the types of job deployment available for SAS Data Integration Studio Jobs.
• Provide an overview of the scheduling process.
• Discuss the types of scheduling servers.
• Discuss the Schedule Manager in SAS Management Console.
• Discuss batch servers.
• Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
• In Database Processing
• Define in-database processing
• Enable in-database processing
• Define and discuss ELT methods
• Use a DBMS function in a SAS DI job