This operator performs the reverse of dimensioning or of the Denorm analysis.
The parameter Name/Value pairs for this operator with a single Value Column are outlined below.
VALUE_COLUMNS ('column')
UNPIVOT_COLUMN ('column')
COLUMN_LIST (‘column’, ‘column’, ...')
COLUMN_ALIAS_LIST ('alias', ‘alias’, ...)
INCLUDE_NULLS (‘No’ / ‘Yes’)
The parameter Name/Value pairs for this operator with multiple Value Columns are outlined below.
VALUE_COLUMNS ('column', 'column' …)
UNPIVOT_COLUMN ('column')
COLUMN_LIST (‘column, column …’, ‘column, column, …’, ...)
COLUMN_ALIAS_LIST ('alias', ‘alias’, ...)
INCLUDE_NULLS (‘No’ / ‘Yes’)
The Hash By, Local Order By and Partition By features of Table Operators don’t apply to TD_UNPIVOT.