Sas 9.1 Etl Studio

Sas 9.1 Etl Studio

4.11 - 1251 ratings - Source

The ETL process consists of all the steps necessary to extract data from different locations, transform raw operational data into consistent, high-quality business data, and load the data into a data warehouse. SAS provides all of this with the addition of an easy-to-use, metadata-driven warehouse management environment. This manual explains how to use SAS ETL Studio to specify metadata for sources, such as tables in an operational system; specify metadata for targets--the tables and other data stores in a data warehouse; and create jobs that specify how data is extracted, transformed, and loaded from sources to targets. This manual also summarizes how to set up servers, libraries, and other resources that SAS ETL Studio requires. A data warehouse for a fictional company, Orion Star Sports a Outdoors, is used to illustrate these tasks. The audience for this manual is users who are responsible for implementing data warehouses and who have a working knowledge of Base SAS software. Supports releases 9.1 and higher of SAS software.The audience for this manual is users who are responsible for implementing data warehouses and who have a working knowledge of Base SAS software. Supports releases 9.1 and higher of SAS software.


Title:Sas 9.1 Etl Studio
Author:SAS Institute
Publisher:SAS Institute - 2004
ISBN-13:

Continue

You Must CONTINUE and create a free account to access unlimited downloads & streaming