Maintaining Data Tables

Preparing to Create Data Tables

Before you create a Data Group and its associated Data Tables, you must first do some preparation, as follows:

Hierarchy of objects	In SAS/Warehouse Administrator, make sure that you have created the appropriate Data Warehouse Environment, Data Warehouse, and Subject.
Input source(s)	Determine which input sources(s) to use for each Data Table. For example, if the input source for a Data Table is an ODD, the ODD must be fully operational. Analyze the input data and determine which columns you want to include in the Data Table. Decide what columns are needed for the Data Table.
Processes	Determine whether the source code, which defines how data moves from input source(s) 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.
Output target	Determine how you want to store each Data 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 Data Table. That is, you can store the table locally or on a remote host.