This course expands on the knowledge acquired in SAS Data Integration Studio: Essentials and provides additional information about setting up change management, working with the Loop transformations, working with slowly changing dimensions, using the loader transformations, working with databases, and defining custom transformations. Also covered are impact analysis, conditional execution, metadata promotion, version control, and establishing checkpoints. Lastly, this course covers deploying jobs for scheduling and integrating with DataFlux.

The self-paced e-learning includes:

• Annotatable course notes in PDF format.
• Virtual lab time to practice.

• Set up change management.
• Work with slowly changing dimensions.
• Work with Loop transformations.
• Create new transformations.
• Examine impact analysis.
• Examine exporting and importing of metadata.
• Establish checkpoints.
• Deploy jobs for scheduling.
• Deploy jobs as SAS Stored Processes.

Who should attend

Formats available	Standard duration
Classroom:	3 days

Before attending this course, you should have completed the SAS Data Integration Studio: Essentials course or have equivalent knowledge. Experience with SAS programming, SQL processing, and the SAS macro facility is recommended. This experience can be gained by completing the SAS Programming 1: Essentials, SAS SQL 1: Essentials, and SAS Macro Language 1: Essentials courses.

This course addresses SAS Data Integration Studio, SAS Analytics Platform software.

• Exploring the platform for SAS Business Analytics.
• Introduction to SAS Data Integration Studio.
• Introduction to the course data and course tasks.
• Reviewing propagation and mapping.

• Introducing change management.
• Establishing a change management environment.

• Introduction to the Loop transformations.
• Iterating a job.
• Iterating a transformation.

• Defining slowly changing dimensions.
• Using the SCD Type 2 Loader and Lookup transformations.
• Using the SCD Type 1 Loader transformation.
• Introducing the Change Data Capture transformations (self-study).

• SAS Data Integration Studio transformations.
• Using the new transformation wizard.

• Reviewing the basics of the Table Loader transformations.
• Exploring the load styles of the Table Loader transformation.
• Managing indexes and constraints during loading.
• Bulk loading DBMS tables.

• Introduction to In-Database processing.
• Using In-Database processing.
• Exploring ELT processing.
• Using DBMS functions

• Analyzing metadata using impact analysis.
• Comparing tables.
• Conditional execution.
• Exploring metadata promotion.
• Exploring version control.
• Establishing checkpoints.

• Introduction.
• Deploying jobs for scheduling.
• Deploying jobs in batch.
• Deploying jobs as stored processes.

• SAS and data quality.
• Using the DataFlux transformations.