what is shared lookup&persistent lookup?
- 4 Answers
- 9643 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 |
What are the types of maping wizards that r to be provided in Informatica?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How to call shell scripts from informatica?
How to display null values on a target & non-null values on a target?
how to design mapping half of source table records into one target and remaining half into another target
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Is it possible to have "5 source & 5 Target" in single mapping?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
how to work with mapplet designer in informatica?
Teradata 
