Databases Reference
In-Depth Information
CHAPTER
8
Registering Data Sources
Sources: Inputs to SAS Data Integration Studio Jobs
119
Example: Using a Source Designer to Register SAS Tables
120
Preparation
120
Start SAS Data Integration Studio and Open the Appropriate Metadata Profile
120
Select the SAS Source Designer
121
Select the Library That Contains the Tables
122
Select the Tables
123
Specify a Custom Tree Group
124
Save the Metadata for the Tables
125
Check In the Metadata
126
Example: Using a Source Designer to Register an External File
126
Preparation
126
About External File Source Designers
127
Start SAS Data Integration Studio and Open the Appropriate Metadata Profile
127
Select an External File Source Designer
128
Specify Location of the External File
129
Set Delimiters and Parameters
130
Define the Columns for the External File Metadata
131
View the External File Metadata
137
View the Data in the External File
138
Check In the Metadata
138
Next Tasks
138
Sources: Inputs to SAS Data Integration Studio Jobs
In general, a source is an input to an operation. In a SAS Data Integration Studio
job, a source is a data store from which information will be extracted, transformed, and
loaded into a target, which can be a data store in a data warehouse, a data mart, or
another data collection.
After you complete the tasks that are described in “Preliminary Tasks for Users” on
page 93, you can register the data sources that will be used in a job. To register a data
source, you will enter metadata about it and save the metadata to a SAS Metadata
Repository.
Your project plan should identify the data sources that are required for a particular
job. For example, the sources that are required to answer specific business questions in
the Orion Star Sports & Outdoors project are listed under each business question. See
the Identifying Sources 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 register
the sources that will be used in a SAS Data Integration Studio job.
Search WWH ::
Custom Search