Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared lookup&persistent lookup?
- 4 Answers
- 11077 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)
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
As union transformation gives UNION ALL output, how you will get the UNION output?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is the difference between informatica 7.0 and 8.0?
what is workflow varible
Different circumstance which drives informatica server to expel records?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
what happens if you try to create a shortcut to a non- shared folder?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
How to go to the older version for a mapping?
What are the advantages of using informatica as an etl tool over teradata?
Teradata 
