Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared lookup&persistent lookup?
- 4 Answers
- 11043 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
shared cache: Data in the cache can be shared between
multiple transformations. It is just sharing the lookup cache.
Persistence cache: The cache can be reused across multiple
session runs.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ripz
Sahred lookup and persistent look ups are the lookups which
are cached once and are used by more than one ETLs. This is
useful when the data in the table which is used for the
lookup is huge and if this table is used in more than once,
then in every ETL considerable amount of time is used for
casching the table everytime if lookup is used individually.
Persistence lookup hence helps in performance improvement.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / raman
integrating service can create the shaaredlookup&persistent
lookup.!
| Is This Answer Correct ? | 0 Yes | 3 No |
How you load distinct records into one target and duplicate records into another target?
What are Business Components in Informatica?
How to read data from flat file source if the data is in paragraph format?
Define Incremental Aggregation?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
What is the surrogate key?
i have 2 session s1 execute s2 load first session fail what is the reason?
What is Collect performance data in informatica and what is the use of it.
Why we need XMLs?
what is the difference between Informatica 7.1 and Abinitio?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Teradata 
