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
What is a grid in Informatica?
How to delete duplicate row using informatica?
Explain the different dimensions.
Differentiate between sessions and batches?
Explain what transformation and how many are there in informatica?
How can we update a record in the target table without using update strategy?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a dimensional model?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
lookup transformation with screenshots
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What differs when we choose the sorted input for aggregator transformation?
What are mapplets? How is it different from a Reusable Transformation?
What is union transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.