Explain About Pivot – Columns To Rows?

1.	Explain About Pivot – Columns To Rows?
Answer» DATA Integrator produces a ROW in the output data set for every VALUE in the designated pivot column. More than one pivot column can be set as per the need of application’s data integration. Pivot Sequence Column – Data Integrator increments a sequence NUMBER for every row created from a pivot column. Non-Pivot column – The columns that need to appear in the target. Pivot Set – A group of pivot columns, unique data field and header column. Data Field Column – It contains the pivot data along with pivot columns values. Header Column – Lists the name of the columns. Pivot Sequence Column – Data Integrator increments a sequence number for every row created from a pivot column. Non-Pivot column – The columns that need to appear in the target. Pivot Set – A group of pivot columns, unique data field and header column. Data Field Column – It contains the pivot data along with pivot columns values. Header Column – Lists the name of the columns.

Answer»

DATA Integrator produces a ROW in the output data set for every VALUE in the designated pivot column.
More than one pivot column can be set as per the need of application’s data integration.

Pivot Sequence Column – Data Integrator increments a sequence NUMBER for every row created from a pivot column.

Non-Pivot column – The columns that need to appear in the target.

Pivot Set – A group of pivot columns, unique data field and header column.

Data Field Column – It contains the pivot data along with pivot columns values.

Header Column – Lists the name of the columns.

Pivot Sequence Column – Data Integrator increments a sequence number for every row created from a pivot column.

Non-Pivot column – The columns that need to appear in the target.

Pivot Set – A group of pivot columns, unique data field and header column.

Data Field Column – It contains the pivot data along with pivot columns values.

Header Column – Lists the name of the columns.

Discussion