Registering Data Targets - SAS Data Integration Studio 3.3 User's Guide - page 142

Follow these steps from this window:
a Click the Target Table icon.
b Click Next .
Because you have set up a default SAS application server, the wizard tries to
open a connection to this default server. If a valid connection to this server exists,
you are prompted for a valid user name and a password. After you provide that
information, the name and description window displays in the Target Table
Designer.
Enter a Name and Description
After you have connected to a SAS application server, use the first window in the
wizard to enter a name and description for the table that you want to register.
Note: The metadata object might or might not have the same name as the
corresponding physical table. You will specify a name for the physical table later in
another window in this wizard. ￿
In this example, in the Name field, enter Total_Sales_By_Employee as the name of the
metadata object. In the Description field, enter the following: Provides a total
sales figure and job information for each salesperson. You can create
the table by joining the source tables ORDER_FACT and ORGANIZATION_DIM.
When the text is complete, click Next . The column selection window displays.
Select Column Metadata from Existing Tables
As noted in “Preparation” on page 140, you will import column metadata from the
ORGANIZATION_DIM and ORDER_FACT tables into the metadata for the
Total_Sales_By_Employee table. Follow these steps:
1 In the Available Tables pane, expand the folder for the repository that contains
metadata for the ORGANIZATION_DIM and ORDER_FACT tables.
2 Expand any subfolders, such as the All Tables subfolder, to find the metadata
for the tables.
3 Find the icon for the table ORGANIZATION_DIM, expand it, and select the
desired columns: Employee_Name, Employee_ID, Job_Title, Company,
Department, Section, Org_Group.