Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

If u r using dynamic cache lookup port will be thier in
thet which option u will select

Question Posted / sunil.knl


If u r using dynamic cache lookup port will be thier in thet which option u will select..

Answer / santhosh

we need to select update else insert/insert else update option in lookup properties tab when we r using dynamic lookup cache.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

Mention a few design and development best practices for informatica?

0 Answers  

What is decode in informatica?

0 Answers  

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

What is aggregate cache in aggregator transforamtion?

5 Answers  

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

What is a filter transformation?

0 Answers  

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories