Interested to Buy Any Domain ? << Click Here >> for more details...
what is shared lookup&persistent lookup?
- 4 Answers
- 10879 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
whats the logic to load the lower level of granularity of data to fact table.
Whats there in global repository
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we get 1st record through Informatica(without sequence number).
What is a repository manager?
How to generate sequence numbers using expression transformation?
Explain joiner transformation in informatica
What can we do to improve the performance of informatica aggregator transformation?
Sequence generator, when you move from develoment to production how will you reset
What is parallel processing in informatica?
Have you worked with/created Parameter file
What are data-driven sessions?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to use procedural logic inside infromatica?
What is complex mapping?
