What are the types of lookup caches?
Answer Posted / rekha
Types are
STATIC CACHE : IT IS A READ ONLY CACHE USED FOR SINGLE
LOOK UP
DYNAMIC CACHE : USE THIS CACHE TO REFLECT THE CHANGED DATA
DIRECTLY ,WHEN THE TARGET TABLE IS LOOKUP
SHARED CACHE : THE CACHE USED AMONG MULTIPLE SESSIONS
PERSISTANT CACHE : THE CACHE USED AMONG MULTIPLE
TRANSFORMATIONS
| Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
How can we use batches?
What happens when a session fails and you click on recover?
What is the difference between informatics 7x and 8x and what is latest version?
How do you load only null records into target? Explain through mapping flow.
Explain the code page compatibility?
Under which circumstances, informatica server creates reject files?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What do you understand by SOA of Informatica?
Briefly define reusable transformation?
Please let me know how to make encryption and decryption with example?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to go to the older version for a mapping?
What is rank transformation?
How you can differentiate between connected lookup and unconnected lookup?