in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
Answer Posted / sbvp
1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to load data in informatica ?
I have a flat file, want to reverse the contents of the flat file
Differentiate between a repository server and a powerhouse?
where to store informatica rejected data? How to extract the informatica rejected data?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the differences between joiner transformation and source qualifier transformation?
What is a router transformation?
Why is sorter an active transformation?
How many types of sessions are there in informatica.please explain them?
Where are the source flat files kept before running the session?
What is the use of source qualifier?
What are the advantages of informatica?
lookup transformation with screenshots