Preparing to Create Detail Tables

In SAS/Warehouse Administrator, make sure that you have created the appropriate Data Warehouse Environment, Data Warehouse, and Subject.

Determine which input source(s) to use for each Detail Table. For example, if the input source for a Detail Table is an ODD, the ODD must be fully operational.

Analyze the input data and determine which columns you want to include in the Detail Table.

Decide what columns are needed for the Detail Table.

Determine whether the source code, which defines how data moves from input sources to output targets, is generated by SAS/Warehouse Administrator or if is it user written and stored in a SAS catalog entry.

Determine the type of Mapping processes, for example, you might need to transform data or generate data.

Determine whether you need to define other processes such as a User Exit process, Data Transfer process, or Record Selector process.

Determine how you want to store each Detail Table. For example, determine what format you want to store the data, such as SAS format or a DBMS.

Determine on what platform you want to store the Detail Table. That is, you could store the table locally or on a remote host.