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



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

What are the join types in joiner transformation?

1 Answers   Informatica,


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


Is there any target staging area in informatica not staging area

0 Answers   Syntel,


How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  






my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


What is a difference between complete, stop and abort?

0 Answers  


What is data movement mode in Informatica and difference between them?

0 Answers  


What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,


what is sql override?what is the use of it?

4 Answers   Sonata,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,


Categories