support & services / Education

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.

Book Your Place Today