SAS Data Integration Studio: Fast Track - DIFT

This intensive training course provides accelerated learning for those learners who will register sources and targets; create and deploy jobs; work with transformations; set up change management; work with slowly changing dimensions; and the scheduling of jobs. This course is for individuals who are comfortable with learning large amounts of information in a short period of time. The SAS Data Integration Studio 1: Essentials and SAS Data Integration Studio 2: Additional Topics courses are available to provide the same type of information in a much more detailed approach over a longer period of time.

Download course description as PDF

Register now

Duration:

5 days - Classroom

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
• 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).

Who should attend?

Data integration developers

Prerequisites

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.

Course Contents:

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 transformtion
• 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 standardisation 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

Software Addressed

This course addresses the following software product(s): Platform for SAS Business Analytics, SAS Data Quality Solution, SAS Data Integration Studio.