support & services / Education

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.

Book Your Place Today