This course expands on the knowledge learned in SAS Data Integration Studio: Essentials and provides additional information on 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, and version control, as well as establishing checkpoints. Lastly, this course covers deploying jobs for scheduling and integrating with DataFlux.
The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.
The e-learning includes:
- digital course notes for self-study
- Virtual Lab: 30 hours of hands-on software practice.
This course can help prepare you for the following certification exam(s): SAS Data Integration Development for SAS 9.
Learn how to
- 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
Data integration developers
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, SAS SQL 1: Essentials, and SAS Macro Language 1: Essentials courses.
This course addresses SAS Analytics Platform, SAS Data Integration Studio software.