Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of lookup caches?
- 10 Answers
- 69053 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 is a transaction control transformation?
Define pmcmd command?
Explain scd type 3 through mapping.
what is SDLC way of code development?
In which transformation you cannot drag ports into it?
State the limitations where we cannot use joiner in the mapping pipeline?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to handle decimal places while importing a flatfile into informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Do you find any difficulty while working with flat files as source and target?
can we override a native sql query within informatica? Where do we do it?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between a repository server and a powerhouse?
