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 differs when we choose the sorted input for aggregator transformation?
Describe data concatenation?
Write the advantages of partitioning a session?
What are the settings that you use to configure the joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
How to partition the Session?
How you can differentiate between connected lookup and unconnected lookup?
Explain the code page compatibility?
permutations of mapplet
Differentiate between a repository server and a powerhouse?
What are active and passive transformations?
How to join three sources using joiner?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a joiner transformation and why it is an active one?