DSXchange

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?

Welcome aboard. :D

Without knowing a lot more about your source data it's impossible to say. For example, how many columns are in each source row? Maybe even a different stage type (such as Complex Flat File) can accomplish your normalization.