Databases Reference
In-Depth Information
Check In the Metadata
Under change management, new metadata objects are added to the Project tree on
the SAS Data Integration Studio desktop, as shown in the following display.
Display 8.6
Project Tree with Metadata Objects for Three Tables
You must check in the new table metadata in order to save it to the change-managed
repository.
1
In the Project tree, select the repository icon (
Project: etlDev4
).
2
From the SAS Data Integration Studio menu bar, select
Project
Check In
Repository
.
All metadata objects in the project repository will be checked into the
change-managed repository. The new objects will be visible in the Inventory tree.
Example: Using a Source Designer to Register an External File
Preparation
An external file is a file that is created and maintained by a host operating system or
by another vendor's software application. SAS can read data from and route output to
external files.
Suppose that you wanted to create a report that requires information from a
comma-delimited external file. Your first task would be to register this file so that it an
be included in a job that creates the report. Because the file is in comma-delimited
format, you would use the Delimited External File source designer wizard to register
the file.
Assume that the following preparations have been made:
The comma-delimited external file is called employeeFlatFile.csv . It contains
information about dependents of Orion Star Sports employees.
You have selected a default SAS application server for SAS Data Integration
Studio, as described in “Selecting a Default SAS Application Server” on page 96.
This server can access the employeeFlatFile.csv
file.
Search WWH ::
Custom Search