Maintaining Detail Logical Tables and Detail Tables

Example: Creating a Detail Table

After you have a Detail Logical Table in which you can group Detail Tables, you can add the Detail Tables. There are different methods you can use to add a Detail Table:

From the Detail Logical Table Properties window, select the Tables tab, and then click Add New Table. The Detail Table Properties window opens for you to define the appropriate metadata for the Detail Table.
In the SAS/Warehouse Administrator Explorer, position the cursor on the Detail Logical Table icon, click the right mouse button, and select Add New Table. The following explanations describe this method.

Note: The following explanations describe the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, Detail Logical Table, and ODD exist. [cautionend]

Define Detail Table Properties

In the SAS/Warehouse Administrator Explorer, position the cursor on the Detail Logical Table (for example, Group Detail Logical Table), click the right mouse button, and select Add New Table. In the Explorer window, a new Detail Table is added under the Detail Logical Table as follows:

[untitled graphic]

To update the default metadata for the table, position the cursor on its icon, click the right mouse button, and select Properties. The Detail Table Properties window displays for you to enter the appropriate information.

General Tab

specifies the table name Customer, a description, an owner, and an administrator.

[untitled graphic]

Columns Tab

specifies the columns to be included in the Detail Table, which does not exist yet.

[untitled graphic]

To import columns from an input source, click Import to display a list of input sources. Select an input source, for example Operational Data Sources. The Import Column Metadata window displays.

From the Import Column Metadata window, which lists the available tables, select an ODD, for example Customer, to display its available columns.

[untitled graphic]

Select the appropriate columns listed under Columns, which for this example are all of the columns. Use the double arrows to move these columns to Selected Columns, and then click OK. You are returned to the Columns tab in the Detail Table Properties window, which now lists the imported columns.

[untitled graphic]

Physical Storage Tab

specifies physical storage attributes. This example specifies the storage format SAS and the load technique Refresh.

[untitled graphic]

Click Define to open the SAS Table Properties window and view the table metadata.

Location Tab

specifies where the SAS table is stored.

[untitled graphic]

Access Location Tab

specifies a location to provide interactive access to the Detail Table. For this example, the check box Use Physical Storage Location as the Access Location is selected by default, which enables the software to use information from the Physical Storage tab to provide interactive access to the table.

[untitled graphic]

Define Process Editor Job

In the Process Editor Job, the Detail Table Customer is specified as the output target and the ODD Customer is specified as the input source. The following Process Editor window shows the Process Flow for the Job:

[untitled graphic]

The processes defined in the Job are as follows:

Mapping Process

The source code to map columns is generated by SAS/Warehouse Administrator, rather than user written, as shown in the Source Code tab:

[untitled graphic]

Column mapping is defined as one-to-one mapping, as shown in the Column Mapping tab:

[untitled graphic]

Note: To produce one-to-one mapping, first click 1 to 1 Mappings on the Column Mapping tab, which opens the One-to-One Column Mapping window. Then, click Quick Map. [cautionend]

Load Step Process

The source code is generated by SAS/Warehouse Administrator, rather than user written, as shown in the Detail Table Load Process Attributes window:

[untitled graphic]

For more information about Process Editor Jobs, see Maintaining Jobs. For more information about processes, see Maintaining Processes.

Top of Page