Jump to: navigation, search

SOLUTION Dimension

Each tenant in iWD can have one or more solutions. A solution can be configured in iWD for testing a new iWD configuration, independent of a production solution. Solution information is stored in the SOLUTION dimension which is populated from iWD GAX Plug-in configuration. Many fact tables in the iWD Data Mart include a SOLUTION_KEY column to join to this dimension.

The SOLUTION Dimension
Field Data Type Description
SOLUTION_KEY int Primary key of this table.
SOLUTION_CONFIG_ID int iWD GAX Plug-in ID for the solution.
SOLUTION_CONFIG_EVENT_ID bigint Event that created or updated the solution record.
SOLUTION_RUNTIME_ID nvarchar(255) iWD GAX Plug-in runtime ID for the solution.
TENANT_KEY int Key to the TENANT dimension, identifying the tenant with whom the solution is associated
SOLUTION_NAME nvarchar(255) Descriptive name of the solution.
CREATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.
VALID_FROM datetime The date, in YYYY-M-D HH:MM:SS F format, from which this solution is valid.
VALID_TO datetime The date, in YYYY-M-D HH:MM:SS F format, until which this solution is valid.
VERSION int Version of the record.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.