SAS Data Integration Studio
Objectives
- register source data and target tables
- create jobs and explore the functionality of the Job Editor
- work with many of the various transformations
- enhance table relationships using integrity constraints, key, and indexes
- work with slowly changing dimensions
- create custom transformation with the Transformation Generation Wizard
- document and deploy jobs
- administer SAS Data Integration Studio
- Incorporate data quality techniques (self-study).
Course Outlines
Introduction to the platform for SAS Business Analytics and SAS Data Integration Studio
- exploring the platform for SAS Business Analytics
- working with SAS Data Integration Studio
- introduction to change management
Introduction to Course Data and Course Scenario
- Explaining the course data
- Explaining how to define target data
- Introduction to the course scenario
Creating Metadata for Source Data
- Setting up the environment
- Registering source data
Creating Metadata for Target Tables
- registering target tables
- importing metadata
Creating Metadata for Jobs
- creating jobs
- exploring functionality of Job Editor
- submitting jobs to create target tables
- specify how to document jobs
- recording job performance statistics
- chaining job flows
- investigating mapping and propagation
Working with Transformations
- working with the extract transformation
- working with summary statistics transformation
- working with the loop transformations
- explaining status handling
- working with the data validation transformation
- working with the sort transformation
- working with the append transformation
- working with the transpose transformation
- working with the apply lookup standardization transformation
Defining Table Relationships
- reviewing the data model
- defining integrity constraints
- defining keys and indexes
- exploring various load techniques
Working with Slowly Changing Dimensions
- defining slowly changing dimensions
- working with SCD Type 2 loader transformation
- working with the lookup transformation
Working with Transformations
- working with the new transformation wizard
Implementing Data Quality Techniques (Self-Study)
- working with the DataFlux IS Job transformation
- working with the DataFlux IS Service transformation
Deployinging Jobs
- specify how to deploy jobs for batch scheduling
- specify how to deploy jobs as stored processes