Footprints Data Model

Table
Table Name Data Mart Load History
Table Definition The history of data mart full and incremental loads. A full load is chunked into 10K row batches and is restartable and re-runnable. An incremental load processes all the activity since the previous run, which is assumed to be a short duration. This table holds an Audit Transaction Id reference to the Audit tables, which identify the last transaction processed. This table is designed to handle many types of data marts in multiple different containers. Currently, only two Ticket data marts are defined and run. If a new data mart fact table were defined, and stored procedures written for the full and incremental load, and all entries defined in the request tables, the data mart java process should manage the loading.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Data Mart Load History Id The automatically generated primary key of the data_mart_load_history table. LONG Yes
Data Mart Name The name of the Data Mart Load History. VARCHAR(255) No
Item Definition Id A Foreign Key to the Definition table. LONG No
Data Load Type Name The name of the Data Load Type. VARCHAR(20) No
Load Process Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) Yes
Load Start Date Begin Date. DATE No
Load End Date Load end date in UTC DATE No
Last Audit Transaction Id A Foreign Key to the Audit Transaction table. LONG No
Is Waiting Indicates if Is Waiting. BOOLEAN Yes