in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
Answer Posted / naga
If the lookup does not change between sessions, you can
configure the transformation to use a persistent lookup
cache. When you run the session, the Integration Service
rebuilds the persistent cache if any cache file is missing
or invalid.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a transaction control transformation?
What are the tuning techniques you applied during your last project
What are the differences between source qualifier and joiner transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain what are the different types of transformation available in informatica.
What are ETL Tools?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain the difference between a data warehouse and a data mart?
What is the use of code page?
pmscmd startworkflow -sv
How can you differentiate between powercenter and power map?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a stored procedure transformation?
Explain in detail scd type 2 through mapping.