Contact No  : +91 8050922145
Skype ID      :  sas.training25
Email ID       :,

DI (Data integration) Training

SAS DI (Data Integration) software using for ETL (Extraction-Transformation-Loading), Data cleansing and Enrichment using SAS Enterprise Environment. Here we can perform the job on click, much coding is not involved. End product of SAS DI is Data mart which use for reporting purpose.

Training Duration:

25 Days

Mode of Training:

Option 1: Instructor Led online training.
Option 2: Instructor led classroom training.

Take Away:

Soft Copy of Books Class notes,
Coding for reference,
Assignments for practice
Interview questions,
Resume preparation.

Course Content / Topics:


1. Define the architecture of the platform for SAS Business Analytics.
2. Describe the available interfaces.
3. Define the change management feature of SAS Data Integration Studio.

Creating Metadata for Source and Target Data

1. Define administrative tasks to be performed for SAS Data Integration Studio.
2. Describe the New Library Wizard.
3. Use Register Tables wizard to register source data.
4. Use Register Tables wizard to register metadata for a Microsoft Access database table using ODBC.
5. Register metadata for a comma-delimited external file.
6. Import and Export Metadata.

Creating Metadata for Target Data and Jobs

1. Describe features of the New Tables wizard.
2. Discuss SAS packages.
3. Discuss importing and exporting of relational metadata.
4. Discuss components of SQL Join's Designer window.
5. Investigate mapping and propagation.
6. Work with performance statistics.
7. Generate reports on metadata for tables and jobs.
8. Define Impact and Reverse Impact Analysis.

Working with Transformations

1. Explain and work on the Extract and Summary Statistics transformation.
2. Explain and work on the Loop transformations.
3. Investigate where status handling is available.
4. Explain and work on the Data Validation transformation.
5. Explain and work on the Rank, Transpose, Append, List and Sort transformations.
6. Explain and work on the Apply Lookup Standardization transformation.
7. Define the Concept of a Checkpoint.

Working with Tables and the Table Loader Transformation

1. Explain reasons to use the Table Loader transformation.
2. Explain various load styles provided by the Table Loader transformation.
3. Explain various types of keys and how to define in SAS Data Integration Studio.
4. Explain indexes and how to define in SAS Data Integration Studio.
5. Explain Table Loader options for keys and indexes.

Working with Slowly Changing Dimensions

1. List the functions of the SCD Type 2 transformation.
2. Work on business keys, surrogate and retained keys.
3. Detect and track changes.
4. Explain the Lookup transformation.

Defining Generated Transformations

1. Define SAS code transformation templates.
2. Create a custom transformation

Deploying Jobs

1. Explain the types of job deployment available for SAS Data Integration Studio Jobs.
2. Provide an overview of the scheduling process.
3. Explain the types of scheduling servers.
4. Explain the Schedule Manager in SAS Management Console.
5. List the applications that can be used to create and execute stored processes.
6. Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
7. Import SAS code.