Overview

This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.

Prerequisites

Before attending this course you should:

  • have experience with SAS programming basics. You can gain this experience by completing the SAS Programming 1: Essentials course.

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

Outline

Introduction

  • exploring the platform for SAS Business Analytics
  • introduction to the data management applications
  • introduction to classroom environment and the course tasks

Working with Change Management

  • introduction to change management
  • establishing a change management environment (self-study)

Creating Metadata for Source Data

  • setting up the environment
  • registering source data

Creating Metadata for Jobs

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

Orion Star Case Study

  • defining and loading the customer dimension table
  • defining and loading the organization dimension table
  • defining and loading the time dimension table

Additional Features for Jobs

  • importing SAS code
  • propagation and mapping
  • chaining jobs
  • performance statistics
  • metadata reports

Working with Transformations

  • introduction
  • using the Extract and Summary Statics transformations
  • exploring SQL transformations
  • establishing status handling
  • using the Data Validation transformation
  • using the Transpose, Sort, Append, Rank and list Data transformations
  • basic standardizations

Software Addressed:

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