TD_UNPIVOT (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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.