Normalizer tr.

[kpmINFO]

Can some one please explain how I can use a normalizer tr in Informatica 6.2 to de normalize data. Below is a sample

col1 col2 col3 col4 col5
1 a b c d
2 a1 b1 c1 d1
3 a2 b2 c2 d2

this is the data in a transformation ( expression tr)
I would like to transfer this data into another expression tr
col1 col2
1 a
1 b
1 c
1 d
2 a1
2 b1
2 c1
2 d1
3 a2
3 b2
3 c2
3 d2

how can I achieve this , if possible give me the most efficient way.

 

[blom0344]

Well, don't want to sound patronizing, but if you are in designer and use the help function to look up the normalizer transformation there is a perfectly clear explanation on how to use it.
Anyway, there is no 'most efficient way', just make sure that you set the parameters for sequence values as you need.

I could explain in my own words, but designer help is all you need....

T. Blom
Information analyst
tbl@shimano-eu.com