Using Connected or unconnected lookup for performance wise which one is preferable?.
Answer Posted / sam
Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is mean by complex business rule ?
What is a pre-defined event and user-defined event?
Explain sessions. Explain how batches are used to combine executions?
What are junk dimensions?
Briefly define reusable transformation?
how to create user defined function (udf) in informatica
How an expression transformation differs from aggregator transformation?
What is the sql query overwrite in source qualifier in informatica
What are the different ways to implement parallel processing in informatica?
What is rank transformation?
Explain how to import oracle sequence into informatica?
What is the Process to creating lookup transformation in informatica
Global and Local shortcuts. Advantages.
What are the differences between source qualifier and joiner transformation?
What is deployment group?