what is shared lookup&persistent lookup?
Answer Posted / santoshkumar chakka
I know abt 4 types lookup's
they are
1.static lookup
2.dynamic lookup
3.persistence lookup
5.No Cache lookup
PERSISTENCE LOOKUP:By default .dat and .idx files are created using session execution time and these are deleted automatically at the end of session execution using persistence property the cache files are not deleted even after session execution.the same cache files are uesed for next exicution
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
can anyone suggest best free Talend data integration training online
Explain incremental aggregation in informatica
design of staging area?
Is it possible to create multiple domains on a single Informatica server?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you use reject loader.
What will be the approach?
Explain about cumulative Sum or moving sum?
Define mapplet?
What are batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Global and Local shortcuts. Advantages.
I have a flat file, want to reverse the contents of the flat file
What are data-driven sessions?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?