what is shared lookup&persistent lookup?
Answer Posted / 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 |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
what are factless facts? And in which scenario will you use such kinds of fact tables.
can u give example for factless fact table
What is lookup transformation?
Which version configuration tool used in ur project?
What is data movement mode in Informatica and difference between them?
what are the deliverables?in your project?
What all are steps in up gradation of Informatica server?
What is different between the data warehouse and data mart?
is it possible to index the data in cache of lkp transformation ?
What is resilience time?
What is a transaction control transformation?
What are multi-group transformations?
What is event and what are the tasks related to it?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?