BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

SAS Data integration Training


We are Provides SAS Data Integration ( DI ) Online Training in India with Real time working Professionals.

SAS BI / DI (Data integration) training

Training Duration: 20 – 25 hours

Take Away:

  1. Soft Copy of SAS books of DI
  2. Class notes,
  3. Coding for reference,
  4. Assignments for practice,
  5. Interview questions,
  6. Resume preparation.

Course Content:

Overview

  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

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

Creating Metadata for Target Data and Jobs

  • Describe features of the New Tables wizard.
  • Explain importing and exporting of relational metadata.
  • Explain SAS packages.
  • Explain components of SQL Join’s Designer window.
  • Investigate mapping and propagation.
  • Work with performance statistics.
  • Generate reports on metadata for tables and jobs.
  • Define Impact and Reverse Impact Analysis.

Working with Transformations

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

Working with Tables and the Table Loader Transformation

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

Working with Slowly Changing Dimensions

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

Defining Generated Transformations

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

Deploying Jobs

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

 

  • Request Demo

  • Add Your Review