Footprints Data Model |
Table |
Name | data_mart_load_history |
Comment | 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. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
data_mart_load_history_id | bigint | The automatically generated primary key of the data_mart_load_history table. | Yes | No |
data_mart_name | varchar(255) | The name of the Data Mart Load History. | No | No |
item_defn_id | bigint | A Foreign Key to the Definition table. | No | Yes |
data_load_type_name | varchar(20) | The name of the Data Load Type. | No | Yes |
load_start_date | datetime | Start time of the load. | No | No |
load_end_date | datetime | end time of the load | No | No |
is_waiting | bit | Deprecated. The Data Mart Load Lock table is used for greater concurrency and performance. | No | No |
load_proc_name | varchar(30) | The name of the Data Mart Load History procedure. | No | No |
last_audit_txn_id | bigint | A Foreign Key to the Audit Transaction table. Indicates the last incremental load processed transaction. | No | Yes |