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