SAS DATA INTEGRATION (DI) - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)8885575549, 040-42627705 | USA: +1 973-619-0109 | UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

SAS DATA INTEGRATION (DI)

SAS DI ONLINE TRAINING

SAS DI ONLINE TRAINING IN INDIA, USA & UK

SAS DI ONLINE TRAINING IN CANADA

SAS DI ONLINE TRAINING IN AUSTRALIA

SAS DI ONLINE TRAINING

SAS DI COURSE CURRICULUM

Download [PDF]

  • Overview of the SAS DI (Data integration) training
      1. Define the architecture of the platform for SAS Business Analytics.
    1. 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.
    1. 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.
    1. 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.
    1. 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.
      2. Explain various load styles provided by the Table Loader transformation.
    1. 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.
    1. 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.
    1. 2. Create a custom transformation
  • Deploying Jobs
      1. Explain the types of job deployment available for SAS Data Integration Studio Jobs.
    1. 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.

SAS DI (Data integration) training

SAS DATA INTEGRATION OVERVIEW

SAS Data Integration Studio provides a powerful visual design tool for building, implementing and managing data integration processes regardless of data sources, applications, or platforms. An easy-to-manage, multiple-user environment enables collaboration on large enterprise projects with repeatable processes that are easily shared. The creation and management of data and metadata are improved with extensive impact analysis of potential changes made across all data integration processes.

SAS Data Integration Studio enables users to quickly build and edit data integration, to automatically capture and manage standardized metadata from any source, and to easily display, visualize, and understand enterprise metadata and your data integration processes.

SAS Data Integration Studio is a component in a number of SAS software offerings, including SAS Data Management Advanced.

SAS Data Integration includes the following changes and enhancements:

New source designer wizard for Cloudera Impala

High Performance Analytics Transformations are now production

Enterprise Decision Management transformation is now production

Code generation supports credential lookup for DataFlux Authentication Servers

SAS package wizards have better support for DataFlux Data Management Servers

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. 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.

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.

DEMO VIDEOS

UPCOMING DEMOS

For updated Schedules please contact
calls