prasad nallapati

• Aug 25th, 2005

 

Narmalizer Transformation is used mainly with COBOL sources where most of the time data is stored in de-normalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data 

Vamshidhar

• Jan 11th, 2006

 

hi,By using Normalizer transformation we can conver rows into columns and columns into rows and also we can collect multile rows from one row

sm1506

• Apr 7th, 2006

 

vamshidhar,

How do u convert rows to columns in Normalizer? could you explain us??

Normally, its used to convert columns to rows but for converting rows to columns, we need an aggregator and expression and little effort is needed for coding. Denormalization is not possible with a Normalizer transformation.