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”.