About this course

Course code TPDIFT48
Duration 4 Days

This course is a 5-day boot camp that covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics It introduces and expands the knowledge of SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information on working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

Prerequisites

Before attending this course you should have experience with

  • SAS programming basics
  • SQL processing
  • the SAS macro facility.

You can gain this experience by completing the SAS Programming 1: Essentials, SAS SQL 1: Essentials, and SAS Macro Language 1: Essentials courses

Who should attend

Data integration developers and data integration architects

Delegates will 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
  • work with slowly changing dimensions
  • work with Loop transformations
  • create new transformations
  • examine impact analysis
  • examine exporting and importing of metadata
  • establish checkpoints in job flow
  • deploy jobs for scheduling
  • deploy jobs as SAS Stored Processes

Outline

Introduction

  • exploring the platform for SAS Business Analytics
  • introducing the data integration applications
  • introducing change management

Introduction to the Course Data and Course Scenario

  • exploring the classroom environment and course data
  • exploring the course tasks

Creating Metadata for Source Data

  • setting up the environment
  • registering metadata for SAS source tables
  • registering metadata for Oracle source tables
  • registering metadata for an ODBC data source
  • registering metadata for external files

Creating Metadata for Target Data

  • registering target data metadata
  • importing metadata

Creating Metadata for Jobs

  • introduction to jobs and the job editor
  • using the Join transformation

Orion Star Case Study

  • define and load several dimension tables
  • define calculated columns
  • work with join types and the Join transformation
  • work with the Table Loader transformation
  • work with the User Written Code transformation

Additional Features for Jobs

  • importing SAS code
  • mapping and propagation
  • chaining jobs
  • examining performance statistics
  • exploring pre-defined metadata reports (self-study)

Working with Transformations

  • using the Extract and Summary Statistics transformations
  • exploring SQL transformations
  • establishing status handling
  • using the Data Validation transformation
  • using the Transpose, Sort, Append, Rank, and List Data transformations
  • using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations (self-study)

Working with Loop Transformations

  • introducing the Loop transformations
  • using the Loop transformations to iterate a job
  • using the Loop transformations to iterate a single transformation (self-study)

Working with Slowly Changing Dimensions

  • defining slowly changing dimensions
  • using the SCD Type 2 Loader and Lookup transformations
  • using the SCD Type 1 Loader transformations
  • introducing the Change Data Capture transformations (self-study)

Defining Generated Transformations (self-study)

  • exploring SAS code transformation templates
  • using the new transformation wizard

Working with the Table Loader Transformations

  • exploring the basics of the Table Loader transformations
  • exploring the load styles of the Table Loader transformation
  • managing indexes and constraints during loading
  • exploring bulk loading for DBMS tables

Working with Databases (self-study)

  • introducing In-Database processing
  • using In-Database processing
  • exploring ELT processing
  • using Oracle functions

Additional Topics for SAS Data Integration Studio Users

  • analysing metadata using impact analysis
  • comparing tables
  • exploring metadata promotion
  • exploring version control
  • establishing checkpoints

Deploying Jobs

  • introduction
  • deploying jobs for scheduling
  • deploying jobs in batch (self-study)
  • deploying jobs as stored processes

Implementing Data Quality Techniques (self-study)

  • exploring SAS and data quality opportunities
  • exploring some basics of DataFlux Data Management Studio profiles and data jobs
  • using the DataFlux Batch Job transformation
  • using the DataFlux Data Service transformation


Software Addressed:

This course addresses Platform for SAS Business Analytics, SAS Data Integration Studio, SAS Data Quality Solution software.

4 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.