Revision as of 22:13, May 5, 2016

Table USER_DATA_CUST_DIM_1

@@ Line 1: / Line 1: @@
 = Table USER_DATA_CUST_DIM_1 =
+{{PDMColumn
+|colName=ID
+|colDesc=The primary key of this table and 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, to indicate the tenant of the IRF resource. The value of this field is identical to the value that is in the corresponding INTERACTION_RESOURCE_FACT record. This value can be used to restrict data access.
+}}
+{{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=DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5
+|colDesc=Stores the value of a certain user-data key. The name of this column, which is configurable and typically matches the user-data key name, may differ in your deployment. If a default value is configured, it is stored when a KVP is missing for an interaction. Attribute values must be of low cardinality, to prevent this dimension from becoming as large as the fact tables.
+This field supports character values only.
+}}
 [[Category:V:GIM:8.5DRAFT]]