Search found 1 match
- Thu Jun 21, 2007 4:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot or Transformer for Normalization??
- Replies: 1
- Views: 743
Pivot or Transformer for Normalization??
The source data is in denormalized fashion. I want to normalize each row of source data into 30 rows. The source data volume is in millions. Considering the huge volume, should the Pivot be used or should the Transformer used for Normalization?