what is the significance of newlookup port in dynamic look up



what is the significance of newlookup port in dynamic look up ..

Answer / suraj kedia

When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.

To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is difference between dimention table and fact table?

1 Answers  


Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,


What is query panel?

1 Answers  






can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


What is an unconnected transformation?

0 Answers   Informatica,


what is row level and column level indicator?

1 Answers   TCS,


What do you mean by worklet?

0 Answers  


Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  


What is meant by a domain?

0 Answers  


What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  


Categories