Planning Your Data Stores and Processes

Valid Inputs and Outputs for Data Stores

If you want SAS/Warehouse Administrator to generate the code for a Job, you must create a Process Flow such as the one shown in Process Flow With Record Selector in the Process Editor. A Process Flow is a user-defined diagram in the Process View of the Process Editor. It is composed of symbols, with connecting arrows and descriptive text, that illustrate the sequence of each process associated with the Job that is selected in the Job Hierarchy of the Process Editor. The Process Flow illustrates how the data moves from input source(s) to output table(s) and what extractions and transformations occur in between.

To create a Process Flow, click an object in the Process View with your right mouse button, then select a valid object to add. The software will not let you add an invalid object. The table in this section lists the valid inputs and outputs for data stores and processes in the Process Editor.

The column headings in the table are as follows:

Data Store	is the data store type.
Inputs	are valid inputs for the data store in the Process Editor. Note: Some data stores can use the old Summary Tables or Summary MDDBs as input. However, no current data store can specify a Summary Table or a Summary MDDB as an output target. (You cannot create these old summary objects.)
Outputs	are the valid outputs for the data store in the Process Editor.
Processes	are the process types that can be defined for the data store.

Valid Inputs and Outputs for Data Stores
Data Store	Inputs	Outputs	Processes
Data File	a SAS data source	ODD, Data File	User Exit, Data Transfer, Record Selector
External File	a data source other than SAS	ODD, Data File	User Exit, Data Transfer
ODD	Data File, External File	Detail Table, Data Table, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	User Exit, Data Transfer, Record Selector, Load
Data Table	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Group, ODD	Detail Table, Data Table, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	Mapping, User Exit, Data Transfer, Load
Detail Table	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	Detail Table, Detail Logical Table, Data Table, Summary Table, Summary MDDB, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	Mapping, User Exit, Data Transfer, Load
Detail Logical Table	Detail Table	Detail Table, Data Table, Summary Table, Summary MDDB, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	User Exit, Data Transfer, Load
OLAP Group	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	Detail Table, Data Table, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	Mapping, Load
OLAP Table	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	Detail Table, Data Table, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	Mapping, User Exit, Data Transfer, Load
OLAP MDDB	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	Detail Table, Data Table, OLAP Group, OLAP Table, OLAP MDDB, Information Mart Item, Information Mart File	Mapping, User Exit, Data Transfer, Load
Information Mart File (within a Data Warehouse)	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	NA	Load
Information Mart File (within an ODD)	Data File, External File, ODD	NA	Load
Information Mart Item (within a Data Warehouse)	Detail Table, Data Table, Detail Logical Table, Summary Table, Summary MDDB, OLAP Table, OLAP MDDB, OLAP Groups, ODD	NA	Load
Information Mart (within an ODD)	Data File, External File, ODD	NA	Load

Top of Page