In Power Center 9.0 we have one feature on lookup transfermation.i.e Return multiple rows if the candition match.
how can we configure this lookup transfermation for getting multiple rows if the canditon match.
Can you please explain this process to me. I want impliment this process in my new requirement....
Thanks In advance.
in the lookup tranformation properties "Look up policy on multipl match", select the option which you want for the output.
I think this option we have in 8 version.
I am asking what is the new lookup feature in V9.
i.e, Multiple rows return.You can configure the Lookup transformation to return all rows that match a lookup condition. A Lookup transformation is an active transformation when it can return more than one row for any given input row.
Transformation guide clearly explains the process, see the transformation guide pageno 245,246..Nothing more to explain
Select lookup transformation --> enter the name for the transformation --> click create , at the bottom you will see return all values on multiple match.
check out the artcle for step by step instruction
Kishu, you are correct!!
we are not able to see that option (use all values) in 9.6.
could you please suggest any one .
Note:In informatica tranformation help that option is available.
got that option,we have to select this option while import lkp table
'Return All Values on Multiple Match
I am using a lookup with property: lookup policy on multiple match=use all values enabled but still only the latest record for the matching condition gets updated.
Unable to figure out how is that possible and If I'm missing something.