Roger_009

 Profile Answers by Roger_009 Questions by Roger_009

• Apr 1st, 2008

 

NORMALIZER transformation

sri.kal

 Profile Answers by sri.kal Questions by sri.kal

• Apr 10th, 2008

 

Using Noamalizer T/R

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Apr 14th, 2008

 

No Doubt .. its normalizer

sahan

 Profile Answers by sahan 

• Jul 16th, 2009

 

You can do it by using aggregator transformation and normalizer transformation.

Ishaan_Kulshrestha

 Profile Answers by Ishaan_Kulshrestha 

• Apr 14th, 2010

 

Hi Sahan,

Please let me know how aggregator is used here. I think Aggregator is required when we denormalise data and here our requirement is to Normailse the data.
Please correct me if I am wrong. Thanks

vijayant.sanjay

 Profile Answers by vijayant.sanjay 

• Sep 7th, 2011

 

Normalizer is basically used to convert rows to columns. I don't think alone normalizer is sufficient to convert columns into rows. In certain scenario you use this sequence of t/f to convert columns into rows
SQ -> Sorter -> Expression -> Aggregator -> Filter -> Target

Scenario : At source we have data like
col1 col 2
1 a
1 b
1 c
2 d
2 e
3 f

At target we want data like
col1 col2
1 a+b+c
2 d+e
3 f

We can achieve this with the above mentioned sequence of transformation.