Chapter 8: Specifying Warehouse Data Stores

 < Day Day Up > 

Targets: Warehouse Data Stores

In general, a target is an output of an operation. In a SAS ETL Studio job, the main targets are data stores in a data warehouse or data mart.

After you have specified the sources for a SAS ETL Studio job, you can specify the targets for that job. Your project plan should identify the targets that are required for a particular job. For example, the targets that are required to answer specific business questions in the Orion Star Sports & Outdoors project are listed under each business question. See the Identifying Targets section under each business question in Chapter 4, "Example Data Warehouse," on page 27.

Use the examples in this chapter, together with general methods that are described in "Specifying Metadata for Sources and Targets" on page 60, to specify metadata for the targets that will be used in a SAS ETL Studio job.

 < Day Day Up > 

SAS Institute - SAS 9.1.3 ETL Studio. User's Guide
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
Year: 2004
Pages: 127
Authors: SAS Institute © 2008-2017.
If you may any questions please contact us: