SAS Institute CanadaSAS Institute Canada
We deliver superior software and services that give people the power to make the right decisions. News & Press Contact Information sas.com Profile Jobs at SAS Canada
Home Products & Solutions Customers SAS Canada Events Services & Support www.sas.com

Using SAS Data Integration Studio to Create Efficient ETL Processes

Duration: 2.0 days
Course fee:
EPTO units: .
CEUs: 1.2 		Available for on-site training or can be scheduled at any SAS training facility if demand warrants.

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

Who should attend

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

Expand/Collapse AllExpand All      Expand/Collapse AllCollapse All      PrintPrint version

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
This course addresses 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.
Course Materials
Students receive a hardcopy of the course notes.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

[SAS Institute Inc.]
This page was created using SAS software.
The Power to Know
   Contact Us     Search     Terms of Use & Legal Information     Privacy Statement   Copyright © 2007 SAS Institute Inc. All Rights Reserved