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 |