SAS Data Integration Studio

Duration: 40 hoursThis course is a 5-day boot camp that covers the content of both SAS Data Integration Studio 1: Essentials and SAS Data Integration Studio 2: 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.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.

Who should attend: Data integration developers and data integration architects.

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.

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