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 |