Informatica logic..

[kpmINFO]

Can some one please advise as to how I can generate the below logic using Informatica 6.2

Here is description

Source data (database data)

A B C D (Column)
1 N Y N
2 Y Y N
3 Y Y Y


Target Data

A Val COL
1 N B
1 N D
2 N D

This is the input data coming from ORCL database
now when ever I see a "N" in the data I need to log this data into a target table as shown above

Whenever there is a "N" in source a new line in the target has to be created , as show above.

 

[blom0344]

You will need to use a normalizer transformation to get the columndata into rows and subsequently filter out the data that you do not want to load.

See for help or documentation how to use normalizer in your mapping........

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

 

[kpmINFO]

Can I use a normalizer tr within a mapping, I mean anywhere after a transformation.

 

[Sridharan]

You cud have tried that one out before replying back so you know for sure if it does work ...

Sri