SAS Data Integration Studio 2: Additional Topics - DI2

This course expands on the knowledge learned in SAS Data Integration Studio 1: Essentials and provides additional information on setting up change management, working with slowly changing dimensions, as well as status handling and change data capture.

3 days - Classroom

Learn how to

• set up change management
• enhance table relationships using integrity constraints, key, and indexes
• work with slowly changing dimensions
• create custom transformations with the Transformation Generator Wizard
• administer SAS Data Integration Studio
• include data quality techniques (self-study).

Who should attend?

Data integration developers

Prerequisites

Before attending this course, you should have completed the SAS Data Integration Studio 1: Essentials course or have equivalent knowledge.

Course Contents

Introduction

• exploring the platform for SAS business analytics
• introduction to course data and course tasks

Working with Change Management

• introduction to change management
• establishing a change management environment

Working with Jobs

• review of jobs and job editor
• job editor features and functionality
• mapping and propagation

Working with Slowly Changing Dimensions

• defining slowly changing dimensions
• using the SCD type 2 loader and lookup transformations
• introducing the change data capture transformations (self-study)

Working with Loop Transformations

• introduction to loop transformations
• iterating a single transformation with loop transformations
• iterating a job with loop transformations

Defining Generated Transformations

• SAS code transformations
• using the new transformation wizard

Working with Tables and the Table Loader Transformation

• basics of the table loader transformation
• load styles of the table loader transformation
• table properties and load techniques of the table loader transformation

Additional Topics for SAS Data Integration Studio Users

• overview
• analysing metadata using impact analysis
• metadata promotion
• deploying jobs for scheduling
• deploying jobs as stored processes

Implementing Data Quality Techniques (Self-Study)

• SAS and data quality
• working with the DataFlux IS transformations

Software Addressed

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