Databases Reference
In-Depth Information
CHAPTER
9
Registering Data Targets
Targets: Outputs of SAS Data Integration Studio Jobs
139
Example: Using the Target Table Designer to Register SAS Tables
140
Preparation
140
Start SAS Data Integration Studio and Open a Metadata Profile
141
Select the Target Table Designer
141
Enter a Name and Description
142
Select Column Metadata from Existing Tables
142
Specify Column Metadata for the New Table
144
Specify Physical Storage Information for the New Table
145
Usage Hints for the Physical Storage Window
145
Specify a Custom Tree Group for the Current Metadata
146
Save Metadata for the Table
147
Check In the Metadata
147
Next Tasks
148
Targets: Outputs of SAS Data Integration Studio Jobs
In general, a target is an output of an operation. In a SAS Data Integration Studio
job, the main targets are data stores in a data warehouse, data mart, or another data
collection.
After you have specified the sources for a SAS Data Integration 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 5, “Example Data Warehouse,” on page 43.
Use the examples in this chapter, together with general methods that are described
in “Registering Sources and Targets” on page 97, to specify metadata for the targets
that will be used in a SAS Data Integration Studio job.
Search WWH ::
Custom Search