Maintaining Detail Logical Tables and Detail Tables

Overview

This chapter assumes that you have evaluated the different detail data stores available in SAS/Warehouse Administrator, as described in Planning Your Data Stores and Processes, and have chosen to create these data stores:

Detail Logical Table	is a metadata record that specifies a SAS table or view that can serve multiple purposes. You can use a Detail Logical Table as a grouping element for Detail Tables or as an individual detail data store, for example, as a view to multiple, related Detail Tables. You can add a Detail Logical Table to a Subject only, and a Subject can have only one Detail Logical Table.
Detail Table	is a metadata record that specifies a SAS table or view or a DBMS table or view that serves as a detail data store. You can add a Detail Table to a Detail Logical Table only.

In general, to maintain a Detail Logical Table and associated Detail Tables:

Define the properties of the Detail Logical Table.
Define the properties of the Detail Table(s).
Define a Process Editor Job that includes the data preparation processes, which prepare the data to be loaded into the data store(s), and the Load Step, which defines the steps to load the data store(s).
Execute the Job.
Verify that the data store(s) are loaded; that is, check logs, use the data utilities, and so on.

Note: The basic steps for creating a Detail Logical Table and Detail Tables are described in the online Help. To display the relevant online Help, in the SAS System Help contents, select Help on SAS Software Products Using SAS/Warehouse Administrator Software Defining Detail Data Stores Maintaining Detail Logical Tables or Maintaining Detail TablesIn addition, you can display Help for most SAS/Warehouse Administrator windows by selecting the Help button on the window. [cautionend]

Top of Page