The ETL_CUSTOM_MAP table is used to configure mapping of task custom attributes to attributes in the I_/H_TASK_FACT and I_/H_TASK_WORK_FACT tables, as well as the CUSTOM_DIM dimension.
|ETL_CUSTOM_MAP_KEY||int||Unique mapping record key.|
|SOLUTION_KEY||int||Key to the SOLUTION dimension identifying the solution for which this mapping is valid. If NULL, the custom mapping applies to all solutions.|
|PROCESS_KEY||int||For which process this mapping is valid. If null applies to all processes.|
|DEPARTMENT_KEY||int||Key to the DEPARTMENT dimension.|
|TYPE||varchar(30)||Indicates where this custom attribute has been configured. One of the following:
|KEY_NAME||varchar(255)||Custom attribute key name in the Interaction Server database.|
|IS_DIMENSION||int||Indicates whether this attribute should be mapped to the CUSTOM_DIM dimension instead of to a fact table.
|CUSTOM_ATTRIBUTE_INDEX||int||Custom attribute index. If IS_DIMENSION is false (0), 1–10; otherwise 1–5.|
This page was last modified on December 19, 2017, at 02:26.