Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared lookup&persistent lookup?
- 4 Answers
- 10877 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 can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Do you find any difficulty while working with flat files as source and target?
How to extract sap data using informatica?
How do you implement unconn. Stored proc. In a mapping?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is the Difference between PowerPlay transformer and power play reports?
Enterprise data warehouse your projects phase by phase explain?
why union transformation is active transformation?
Can we use the mapping parameters or variables created in one mapping into another mapping?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
how to remove staging area
Teradata 
