Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table STRATEGY =
 
= Table STRATEGY =
  
 +
{{PDMColumn
 +
|colName=STRATEGY_KEY
 +
|colDesc=The surrogate key that is used to join this dimension table to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TENANT_KEY
 +
|colDesc=The surrogate key that is used to join the TENANT dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CREATE_AUDIT_KEY
 +
|colDesc=The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=UPDATE_AUDIT_KEY
 +
|colDesc=The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify recently modified data.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STRATEGY_TYPE
 +
|colDesc=The strategy type. This field is set to one of the following values:
 +
 +
- Unspecified
 +
- RoutingStrategy
 +
 +
This value can change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STRATEGY_TYPE_CODE
 +
|colDesc=The strategy type code. This field is set to one of the following values:
 +
 +
- UNSPECIFIED
 +
- ROUTINGSTRATEGY
 +
 +
This value does not change with localization.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=STRATEGY_NAME
 +
|colDesc=The name of the strategy.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=PURGE_FLAG
 +
|colDesc=This field is reserved.
 +
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 22:09, May 5, 2016

Table STRATEGY

Comments or questions about this documentation? Contact us for support!