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