This course is in a boot-camp format. It includes the content of both SAS Data Ingegration Studio: Essentials and SAS Data Integration Studio: Additional Topics. It introduces and expands the knowledge of SAS Data Integration Studio and contains topics about registering sources and targets; creating and working with jobs; and working with transformations. This course also provides information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.
The self-study version of this course contains structured course notes that provide a detailed overview and exercises that help you develop essential skills. There is also a Virtual Lab that enables you to practice what you learn in the course.
The e-learning version includes the following:
- digital course notes for self-study
- Virtual Lab: 50 hours of hands-on software practice
Learn how to
- register source data and target tables
- create jobs and use the functionality of the Job Editor
- work with many of the transformations
- apply slowly changing dimensions
- work with Loop transformations
- create new transformations
- evaluate impact analysis
- export and import metadata
- establish checkpoints in job flow
- set up jobs for scheduling
- deploy jobs as SAS Stored Processes.
Who should attend
Data integration developers and data integration architects
Before attending this course, you should have experience with
- SAS programming basics
- SQL processing
- the SAS macro facility.
You can gain this experience 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 Data Quality Solution, SAS Analytics Platform software.
