SAS DI

  • Overview of the SAS DI (Data integration) training
  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.
  2. Use Register Tables wizard to register source data.
  3. Use Register Tables wizard to register metadata for a Microsoft Access database table using ODBC.
  4. Register metadata for a comma-delimited external file.
  5. Import and Export Metadata.
  • Creating Metadata for Target Data and Jobs
  1. Describe features of the New Tables wizard.
  2. Explain SAS packages.
  3. Explain importing and exporting of relational metadata.
  4. Explain 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 Transformation1. Explain reasons to use the Table Loader transformation.
  1. Explain various load styles provided by the Table Loader transformation.
  2. Explain various types of keys and how to define in SAS Data Integration Studio.
  3. Explain indexes and how to define in SAS Data Integration Studio.
  4. 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.

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.