This course covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics. It introduces and expands the knowledge of SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information on working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.
Targeted towards Data integration developers and data integration architects.
Learn how to:
- Register source data and target tables
- Create jobs and explore the functionality of the job editor
- Work with many of the various transformations
- Work with slowly changing dimensions
- Work with Loop transformations
- Create new transformations
- Examine impact analysis
- Examine exporting and importing of metadata
- Establish checkpoints in job flow
- Deploy jobs for scheduling
- Deploy jobs as SAS Stored Processes.
Prerequisites
Before attending this course, you should have experience with
- SAS programming basics
- SQL processing
- SAS macro facility.
- You can gain this experience by completing the following
- 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.
Course Outline
- Working with Change Management
- Creating Metadata for Source Data
- Creating Metadata for Target Data
- Creating Metadata for Jobs
- Orion Star Case Study
- Additional Features for Jobs
- Working with Transformations
- Working with the Loop Transformations
- Working with Slowly Changing Dimensions
- Creating Custom Transformations
- Working with the Table Loader Transformations
- Working with Databases
- Additional Topics
- Deploying Jobs
The fees is inclusive of
- Fee: ₹60,000+GST | Duration: 40 Hours
- Training & Digital Badge
- Course material
- 2 attempts of Global certification
The SAS® Global Certification Program allows you to validate your SAS® software skills and earn the globally-recognised credential endorsed by SAS®.
Earn a Digital Badge
Stand out from your peers. You’ve earned it.
When you earn an internationally recognized credential from SAS, you also earn a digital badge that you can share on your social media sites.
