what is shared lookup&persistent lookup?
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 |
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
in which situations do u go for starflake schema ?
What are the new features of informatica 9.x in developer level?
how to declare array in plsql?
In session log thier should not be a single error how will u do
Explain the types of lookup transformation?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
differences between service based and product based?
explain about lookup t/r?
Design a mapping to load a target table with the following values from the above source?
In Which scenario did u used Incremental loading?
What is update strategy transform?