•
For staging tables:
–
INTEGRATION_ID, DATASOURCE_NUM_ID •
For dimension and fact tables:
– INTEGRATION_ID, DATASOURCE_NUM_ID, ROW_WID,
ETL_PROC_WID
When
you create a new dimension or fact table, use the required system columns that
are part of each of the Oracle Business Analytics Warehouse tables to maintain
consistency and enable you to reference existing table structures.
For
staging tables, the following columns are required:
•
INTEGRATION_ID:Stores the
primary key or the unique identifierof a record as in the source table
•
DATASOURCE_NUM_ID: Stores the
data source from which the data is extracted
For
dimension and fact tables, the required columns are the INTEGRATION_IDand
DATASOURCE_NUM_ID columns as well as the following:
• ROW_WID:A sequence
number generated during the ETL process, which is used as a unique
identifierfor the Oracle Business Analytics Warehouse
• ETL_PROC_WID:Stores the
ID of the ETL process information
No comments:
Post a Comment