SAS /
SAS DI (Data Integration)

SAS DI (Data Integration)

SAS DI (Data Integration) Online Training:

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Any Functional/technical background consultants are eligible to learn SAS DI (Data Integration) Online Training.

  • 1

    Define the architecture of the platform for SAS Business Analytics

    00:00
  • 2

    Describe the available interfaces

    00:00
  • 3

    Define the change management feature of SAS Data Integration Studio

    00:00
  • 4

    Discuss the DataFlux Integration Server

    00:00
  • 1

    Define administrative tasks to be performed for SAS Data Integration Studio

    00:00
  • 2

    Describe the New Library Wizard

    00:00
  • 3

    Use Register Tables wizard to register source data

    00:00
  • 4

    Use Register Tables wizard to register metadata for a Microsoft Access database table using ODBC

    00:00
  • 5

    Register metadata for a comma-delimited external file

    00:00
  • 6

    Import and Export Metadata

    00:00
  • 1

    Describe features of the New Tables wizard

    00:00
  • 3

    Discuss importing and exporting of relational metadata

    00:00
  • 4

    Discuss components of SQL Join’s Designer window

    00:00
  • 5

    Investigate mapping and propagation

    00:00
  • 6

    Work with performance statistics

    00:00
  • 7

    Generate reports on metadata for tables and jobs

    00:00
  • 8

    Define Impact and Reverse Impact Analysis

    00:00
  • 1

    Discuss and use the Extract and Summary Statistics transformation

    00:00
  • 2

    Discuss and use the Loop transformations

    00:00
  • 3

    Investigate where status handling is available

    00:00
  • 4

    Discuss and use the Data Validation transformation

    00:00
  • 5

    Discuss and use the Rank, Transpose, Append, List and Sort transformations

    00:00
  • 6

    Discuss and use the Apply Lookup Standardization transformation

    00:00
  • 7

    Define the Concept of a Checkpoin

    00:00
  • 1

    Discuss reasons to use the Table Loader transformation

    00:00
  • 2

    Discuss various load styles provided by the Table Loader transformation

    00:00
  • 3

    Discuss various types of keys and how to define in SAS Data Integration Studio

    00:00
  • 4

    Discuss indexes and how to define in SAS Data Integration Studio

    00:00
  • 5

    Discuss Table Loader options for keys and indexes

    00:00
  • 1

    List the functions of the SCD Type 2 transformation

    00:00
  • 3

    Define surrogate and retained keys

    00:00
  • 5

    Discuss the Lookup transformation

    00:00
  • 1

    Define SAS code transformation templates

    00:00
  • 2

    Create a custom transformation

    00:00
  • 1

    Discuss the types of job deployment available for SAS Data Integration Studio Jobs

    00:00
  • 2

    Provide an overview of the scheduling process

    00:00
  • 3

    Discuss the types of scheduling servers

    00:00
  • 4

    Discuss the Schedule Manager in SAS Management Console

    00:00
  • 6

    List the applications that can be used to create and execute stored processes

    00:00
  • 7

    Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process

    00:00
NA