sn3508

 Profile Answers by sn3508 

• Oct 25th, 2006

 

I hope you're asking about the 'add a new port' button in the lookup transformation.  If the answer is yes, this button creates a port where we can enter the name, datatype,...of a port.  This is mainly used when using unconnected lookup this reflects the datatype of the input port.

vijayarjun

• Nov 10th, 2006

 

Seems u r talking newlook up row, when u configure u lookup as dyanamic lkp cache, by default it will generates newlkprow, it tells the informatica whether

the row u got is existing or new row, if it is new row it passes data. or else it discards.

adil

• Nov 28th, 2006

 

This port is added by PC Client :-'Designer" to a Lookup transformation when ever dynamic cache is used.This port is a indicator to Infa server action ,whether it is inserts or upates the dynamic cache,through a numeric value.[0,1,2].

Bobby

• May 17th, 2007

 

The new port in lookup transformation is Associative port

Cheers,
Bobby

srikanth

• Nov 18th, 2011

 

How to get total as new row and sum as 10.000

Code
source


name    sal


aaaa      2000


bbbb      3000


abcd       5000


 


 


Target


name    sal


aaaa     2000


bbbb     3000


abcd      5000


total      10000 


 

venkat

• Dec 14th, 2011

 

In the look up properties whenever you check the dynamic lookup cache is enable, in lookup table new column is added automatically that is newlooup port. If the new lookup port is 0 then there is no change. If it is 1 insert and if it is 2 update.