Footprints Data Model

Table
Table Name Data Mart Load Lock
Table Definition A pessimistic lock table designed to prevent multiple loads from running against the same item. It is also used to count and throttle the number of simultaneous loads. Both the full and incremental loads drop and create tables so that faster non-logged database operations can be used (Select * INTO..., CREATE TABLE AS SELECT *...) The tables have item specific names, so they must single thread.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Data Mart Name The name of the Data Mart Load Lock. VARCHAR(255) Yes
Item Definition Id A Foreign Key to the Definition table. LONG Yes
Is Locked Indicates if Is Locked. BOOLEAN Yes
Owning Process Id The name of the Data Mart Load Lock. VARCHAR(255) No
Data Mart Load Lock Id A Foreign Key to the Data Mart Load Lock table. LONG No