Maintaining Detail Logical Tables and Detail Tables

Example: Linking from a Detail Logical Table to an Existing Detail Table

SAS/Warehouse Administrator provides a linking capability that enables Detail Logical Tables in different Subjects to share individual Detail Tables. That is, a single Detail Table needs to be defined and stored only once but can be linked to from any number of Detail Logical Tables.

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, Subjects, Detail Logical Tables, and Detail Table exist. [cautionend]

Create a Link

To link from a Detail Logical Table to an existing Detail Table (in another Detail Logical Table), position the cursor on the Detail Logical Table icon from which you want to create the link, click the right mouse button, and select Properties. The Detail Logical Table Properties window displays. Select the Tables tab, which specifies the Detail Tables that are members of the Detail Logical Table.

[untitled graphic]

Click Link Existing Table to display a list of existing Detail Tables, and then select a Detail Table from the list. The selected Detail Table becomes a member (by means of a link) of the current Detail Logical Table.

[untitled graphic]

Top of Page