Target Field | Description |
---|---|
Surrogate Key | |
<Fact_name_prefix>_UDDn_KEY For example: The surrogate key for Asset Location UDD is ASSET_LOC_UDD1_KEY | <Fact name> User Defined Dimension n Dimension Surrogate Key For example: Asset Location User Defined Dimension 1 Dimension Surrogate Key |
Natural Keys | |
UDD1_CD | User Defined Dimension 1 Code |
Attributes | |
UDD1_DESCR | User Defined Dimension 1 Description |
User Defined Attributes | |
UDF1_CD | User Defined Field 1 Code |
UDF1_DESCR | User Defined Field 1 Description |
UDF2_CD | User Defined Field 2 Code |
UDF2_DESCR | User Defined Field 2 Description |
UDF3_CD | User Defined Field 3 Code |
UDF3_DESCR | User Defined Field 3 Description |
UDF4_CD | User Defined Field 4 Code |
UDF4_DESCR | User Defined Field 4 Description |
UDF5_CD | User Defined Field 5 Code |
UDF5_DESCR | User Defined Field 5 Description |
UDL1_CD | User Defined Field Long 1 Code |
UDL1_DESCR | User Defined Field Long 1 Description |
UDL2_CD | User Defined Field Long 2 Code |
UDL2_DESCR | User Defined Field Long 2 Description |
UDL3_CD | User Defined Field Long 3 Code |
UDL3_DESCR | User Defined Field Long 3 Description |
UDL4_CD | User Defined Field Long 4 Code |
UDL4_DESCR | User Defined Field Long 4 Description |
UDL5_CD | User Defined Field Long 5 Code |
UDL5_DESCR | User Defined Field Long 5 Description |
COMMENT1 | Comment 1 |
COMMENT2 | Comment 2 |
COMMENT3 | Comment 3 |
COMMENT4 | Comment 4 |
COMMENT5 | Comment 5 |
Data Load Attributes | |
EFF_START_DTTM | Effective Start Date/Time |
EFF_END_DTTM | Effective End Date/Time |
DATA_LOAD_DTTM | Data Load Date/Time |
DATA_SOURCE_IND | Data Source Indicator |
JOB_NBR | Job Number |
Property | Value |
Target Table | CD_ABNORMAL_DEVICE_LOG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_ABNORMAL_DEVICE_LOG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CALL_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CALL_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CITY_OUTG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CITY_OUTG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CTRL_ZONE_OUTG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CTRL_ZONE_OUTG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_ACTIVITY_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_ACTIVITY_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CUST_OUTG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CUST_OUTG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CUST_OUTG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CUST_OUTG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_DAMAGE_ASMT_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_DAMAGE_ASMT_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_DAMAGE_ASMT_DETAIL_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_DAMAGE_ASMT_DETAIL_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_JOB_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_JOB_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_OUTG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_OUTG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CALL_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CALL_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_CREW_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_JOB_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_JOB_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_STORM_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_STORM_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_SEG_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_SEG_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_STATE_UDD1 |
Table Type | Dimension |
SCD Type | Type 2 |
Property | Value |
Target Table | CD_SW_PLAN_STATE_UDD2 |
Table Type | Dimension |
SCD Type | Type 2 |