What are the types of lookup caches?
- 10 Answers
- 65583 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
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 are the advantages of using informatica as an etl tool over teradata?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How we can create indexes after completing the loan process?
What is a dimensional model?
What is complex mapping?
What are the components of Informatica? And what is the purpose of each?
How union transformation is used?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is sequence generator transformation in informatica?
What is Data Caches size?
What do mean by local and global repository?
What is rank transformation in informatica
What do think which one is the better joiner or look up?
How do you convert single row from source into three rows into target?
what is diff b/t sorter t/r and agg have the option sorter property...
