Main Tasks for Users - SAS Data Integration Studio 3.3 User's Guide - page 98

Data Store Method for Specifying Metadata

One or more tables that exist in physical storage
and that can be accessed with an OLE DB driver,
such as a table that is stored in an OLE DB Oracle
database.

OLE DB source designer. See “Source
Designer Example: Generate Metadata for
an OLE DB Table” in the Help for SAS Data
Integration Studio.

A comma-delimited file or a similar external file
that exists in physical storage.

External File source designer. See “Example:
Using a Source Designer to Register an
External File” on page 126.

A single table that does not exist in physical storage,
such as a table that is created when a SAS Data
Integration Studio job is executed for the first time.

Target Table Designer. See “Example: Using
the Target Table Designer to Register SAS
Tables” on page 140.

Generate metadata for a table when a specific
source designer for that kind of table is not
available. An example might be one or more tables
that are defined in an XML file.

Generic source designer. See “Source
Designer Example: Generate Metadata for
an XML Table” in the Help for SAS Data
Integration Studio.

Add and maintain a cube. Cube Designer. See “Working with OLAP

Cubes” on page 116.

Registering DBMS Tables with Keys
Tables in a database management system often have primary keys, unique keys, and
foreign keys.
A primary key is one or more columns that are used to uniquely identify a row in a
table. A table can have only one primary key. The column(s) in a primary key cannot
contain null values.
A unique key is also one or more columns that can be used to uniquely identify a row
in a table. A table can have one or more unique keys. Unlike a primary key, a unique
key can contain null values.
A foreign key is one or more columns that are associated with a primary key or
unique key in another table. A table might have one or more foreign keys. A foreign
key is dependent upon its associated primary or unique key. In other words, a foreign
key cannot exist without a primary or unique key.

Note: When specifying metadata for a DBMS table with foreign keys, if you want to
preserve the foreign key, you must specify metadata for all of the tables that are
referenced by the foreign keys. ￿
For example, suppose that Table 1 had foreign keys that referenced primary keys in
Table 2 and Table 3. To preserve the foreign keys in Table 1, you could use the Metadata
Importer wizard or a source designer wizard to import metadata for Tables 1, 2, and 3.

Importing and Exporting Metadata

Introduction
SAS Data Integration Studio is a SAS Open Metadata Architecture application. It can
share metadata repositories with other SAS Open Metadata Architecture applications,