SAS® Data Integration Studio: Fast Track

Course code: DIFAST

This course introduces SAS Data Integration Studio and includes topics about change management, registering source data and target data in metadata, creating and working with jobs, and working with transformations. The course also provides information about creating iterative processes, creating conditional processes, defining new transformations, in-database processing, analyzing metadata, promoting metadata, versioning metadata, and deploying jobs.

The self-paced e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual lab time to practice.
810 EUR

980 EUR including VAT

The earliest date from 08.12.2025

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 08.12.2025

Type: Virtual

Course duration: 2 days

Language: en

Price without VAT: 810 EUR

Register

Starting date: 16.12.2025

Type: Virtual

Course duration: 4 days

Language: en

Price without VAT: 2 165 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 810 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
08.12.2025 Virtual 2 days en 810 EUR Register
16.12.2025 Virtual 4 days en 2 165 EUR Register
Upon request In-person/Virtual 2 days en/cz 810 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

Learn How To
  • View a sample job.
  • Work with change management.
  • Create metadata for source data, target data, and jobs.
  • Work with propagation and mapping in jobs.
  • Establish status handling in jobs.
  • Work with various transformations (data, SQL, analysis).
  • Create iterative processes with the Loop and Loop End transformations.
  • Create conditional processes with the Conditional Start and Conditional End transformations.
  • Create custom transformations.
  • Work with the Table Loader transformation.
  • Process in-database.
  • Analyze metadata using impact and reverse impact analysis.
  • Promote metadata.
  • Version metadata by creating archives.
  • Deploy jobs for scheduling.

Target group

Data integration developers and data integration architects

Course structure

Getting Started with SAS Data Integration Studio

  • Introduction to SAS Data Integration Studio.
  • Exploring the course environment.
  • Viewing a sample job.
  • Working with change management.Creating Metadata for Source Data
  • Registering SAS libraries.
  • Registering SAS table metadata.
  • Registering DBMS table metadata.
  • Registering ODBC data source table metadata.
  • Registering metadata for external files.Creating Metadata for Target Data
  • Registering target data metadata.
  • Importing metadata.Creating Metadata for Jobs
  • Creating jobs.
  • Using transformations.
  • Working with the Join transformation.Orion Star Case Study
  • Creating the star schema.Additional Features for Jobs
  • Working with propagation and mappings.
  • Establishing status handling for transformations and jobs.Working with Transformations
  • Using data transformations.
  • Using SQL transformations.
  • Using analysis transformations.Creating Iterative Processes
  • Introduction to iterative processing.
  • Creating the control table.
  • Creating the parameterized job.
  • Creating the iterative job.Creating Conditional Processes
  • Using control transformations.
  • Creating a conditional process.Creating Custom Transformations
  • Working with transformation templates.
  • Creating custom transformations.
  • Using custom transformations.Working with the Table Loader Transformation
  • Introduction to table loader transformations.
  • Exploring load styles.
  • Managing indexes and constraints.Working with Databases
  • Introduction to in-database processing.
  • Using in-database processing.
  • Exploring processing techniques.Analyzing, Promoting, and Versioning Metadata
  • Analyzing metadata using impact analysis.
  • Promoting metadata.
  • Versioning metadata.Deploying Jobs
  • Introduction to deployment.
  • Deploying and scheduling jobs.

Prerequisites

Before attending this course, you should have experience with the following:;

  • SAS programming basics.
  • SQL processing.
  • 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.

Do you need advice or a tailor-made course?

onas

product support

ComGate payment gateway MasterCard Logo Visa logo