Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared lookup&persistent lookup?
- 4 Answers
- 11046 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
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
How to go to the older version for a mapping?
Define update strategy?
What are the components of Informatica? And what is the purpose of each?
what is INFORMATICA TESTING process
What is the difference between stop and abort in informatica
How to implement security measures using repository manager?
What is a joiner transformation and why it is an active one?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a filter transformation and why it is an active one?
Can we create a Integration service without a Repository service and vice versa?
How does a sorter cache works?
can u any challenge your project?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the advantages of using informatica as an etl tool over teradata?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
