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 flashback table ? Advance thanks
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Define enterprise data warehousing?
What is informatica metadata and where is it stored?
What is the difference between router and filter?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the reusable transformations?
What is informatica powercenter repository?
What is source qualifier transformation in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain sessions and how many types of sessions are there?
What is lookup change?
whats the logic to load the lower level of granularity of data to fact table.
Explain the etl program with few examples.
What is an active transformation?