SAS India | Training

Training

View all Courses

Roles Based Courses

Public Training

Course Details

Training Schedule

Special Offers

On-Site Training

Business Knowledge Series

SAS Solution Lines

Authorized Training Center

Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Sources

Duration: 3 Days

Audience
This Level III course is for data warehouse project leaders, ETL designers, systems experts, and/or data modelers who will be involved in the extraction, transformation, and loading of data into a warehouse. This course requires the SAS 9 Intelligence Platform.

Course Description
This course provides an overview of SAS Data Integration Studio, formerly known as SAS ETL Studio. You learn how to navigate through the SAS Data Integration Studio interface and how to extract, transform, and load data using SAS Data Integration Studio. Additional topics include how to use SAS Data Integration Studio plug-ins and data warehouse management such as change management, scheduling, and use of metadata.

Course Contents Overview of SAS 9 Business Intelligence Platform and SAS Data Integration Studio
	Business Intelligence overview
	Business Intelligence Information Consumers
	navigating in SAS Data Integration Studio

Working Under Change Management
	What is change management?
	repository types
	using change management

Designing the Course Data Mart
	planning a data warehouse
	course data for the Orion Star company
	Orion Star data models

Building a Data Mart
	review of the case study
	defining the source data
	defining the target tables
	loading the target tables

Transformations for Slowly Changing Dimensions
	defining slowly changing dimensions
	using the SCD Type 2 Loader transformation
	using the Fact Table Lookup transformation
	using the Surrogate Key Generator transformation
	using the Key Effective Date transformation

Job Scheduling
	scheduling SAS Data Integration Studio jobs

Administering SAS Data Integration Studio
	setup tasks for SAS Data Integration Studio
	setting up change management
	security planning and implementation (self-study)

Prerequisites Before attending this course, you should be familiar with:
	the SAS programming language
	data modeling concepts



	call: 91-22-6749 2222 fax: 91-22-6749 2299
	training.india@sas.com
	enquire now
	register now