Question about filter transformation 2

[jisoo23]

Hello,

I'm running a mapping that includes an expression transformation with a "decode" function running in it. That column with the "decode" is linked to another column in the following filter transformation. This is primarily to weed out certain unwanted records from a SQL query. My question is that in the filter transformation, the column that's linked to the decode column is defaulted to an incoming and outgoing port. Does this mean that I have to have this column finish all the way to the target? Meaning do I have to have the same column in every transformation from then on all the way to the end of the mapping? Any help is appreciated!

Thanks,
Jisoo23

 

[bsellick]

Based on using v7.x, my answer is no. You don't necessarily have to follow Informatica's default actions. If the field you are talking about is not needed farther downstream, then in most cases, you can shutoff the output.

 

[blom0344]

Same goes for versions 4,5,6.
Add an expression transformation after the filter and there you can choose which ports you want to continue in the mapping....

Ties Blom
Information analyst
tbl@shimano-eu.com

 

[jisoo23]

blom0344: Add an expression *after* the filter? I thought it was the other way around? I have an expression transformation with several data ports, one of which is output only and contains a "DECODE" statement like this:

DECODE(TRUE,
DATAPORT1 = 'U', 'N',
DATAPORT2 = '3', 'N',
'Y')

This port is linked to another port with the same name in the next transformation (which is a filter trans). The other data ports are linked respectively in the filter trans as well. Is this the right way of doing it? I ran several tests and somehow it runs but does not do any filtering...any ideas are appreciated.

Thanks!
Jisoo23

 

[blom0344]

No, the correct flow is as follows:

1. Expression transformation with decode
2. Filter transformation to apply filter
3. Expression transformation to just continue those ports that you need further in the mapping

You have to set the proper filter expression of course in the filter transformation itself

Ties Blom
Information analyst
tbl@shimano-eu.com

 

[jisoo23]

Thanks, that did it. Appreciate the help!