About this course

Course code TPDI148
Duration 3 Days

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.

3 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.