Question: how pivot stage works in datastage?
Answer: Pivot Enterprise stage: The Pivot Enterprise stage is a processing stage that pivots data horizontally and vertically. Horizontal pivoting maps a set of columns in an input row to a single column in multiple output rows.