Table Structures

If you are currently loading data into the data warehouse using AIF DATA batch jobs and need to access database tables for debugging or validation purposes, there are naming and format conventions used on each aggregate table. A base intersection table is abbreviated using the following notations:

Table 6-1 Data Warehouse Base Fact Structure

Table Name Component	Explanation
W_	Most data warehouse tables start with a “W” to denote a core data warehouse object.
IT	Abbreviation for Item
LC	Abbreviation for Location
DY	Abbreviation for Day
WK	Abbreviation for Week
_D	Dimensional tables end with “D”
_F	Base intersection fact tables end with “F”
_A	Aggregate tables end with “A”

Using the above notation, you may interpret the table W_RTL_SLS_IT_LC_WK_A as “Sales aggregate table at the item/location/week intersection”.