Using SAS Data Integration Studio to Create Efficient ETL Processes

Duration:

2 days

This course provides critical ETL performance, tuning, and capacity information for SAS 9 and SAS Data Integration Studio. The course introduces ETL concepts and covers ETL performance topics in depth and with examples as needed.

Learn how to

• Analyze and debug ETL flows
• Gain efficiency quickly
• Set up the system environment
• Customize advanced performance techniques.

Who should attend:

SAS Data Integration Studio users who want to learn to improve performance of ETL processes

Prerequisites

Before attending this course, you should have attended the SAS Programming 1: Essentials course (or have equivalent experience). Knowledge of the SAS macro language is helpful. Also, a good understanding of SAS Data Integration Studio is necessary. This knowledge can be obtained by attending the Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Sources course.

Course Contents

Tracking Efficiency in ETL Flows

• What is the SAS Intelligence Platform?
• Important concepts for SAS Data Integration Studio
• Measuring efficiencies

Basic ETL Performance Tuning

• Working with intermediate files
• Views or physical tables for ETL flows
• Data quality considerations
• Transformation and column optimization
• Status handling and return code check

Working with Data

• Keys
• Indexes
• Data functions
• Counting rows
• Load techniques

Sorts and Joins

• Overview of process intensive tasks
• Tuning sort performance
• Optimizing join performance

Dimensional Models

• What is a star schema?
• Defining slowly changing dimensions
• Building the dimensions
• Building the fact tables

Working with RDBMs

• Optimizing processing with RDBMSs

Optimizing the Physical Environment

• Overview
• Hardware and memory optimization
• Monitoring performance

Software Addressed

This course addresses the following software product(s): SAS Data Integration Studio, SAS Data Quality Solution, SAS Intelligence Platform. This course addresses SAS Data Integration Studio and uses Base SAS software programming techniques.