Sign Up Login


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

When we are using Dynamic Cache,which options we will select
in session level?

Question Posted / brahmaiah.dwh


When we are using Dynamic Cache,which options we will select in session level?..

Answer / ankit

You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".

Thanks,
Ankit

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

can you use flat file for repository?why?

2 Answers   TCS,

why we need informatica

2 Answers   HCL,

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

What is difference between maplet and reusable transformation?

2 Answers  

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

What is joiner change?

0 Answers  

For more Informatica Interview Questions Click Here
Categories