what is the main advantage of unconnected lookup
Answer Posted / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup?
What is workflow? What are the components of workflow manager?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a filter transformation?
What is incremental aggregation?
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 ?
Is stop and abort are same in informatica?
What is resilience time?
What is sorter transformation?
What is joiner transformation?
Why do we need informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to generate sequence numbers?
Global and Local shortcuts. Advantages.
How can we use mapping variables in informatica?