which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / 78swapnil
All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is incremental aggregation?
How can we improve session performance in aggregator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the designer tools for creating transformations?
What is dynamic cache?
What are the settings that you use to configure the joiner transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is depict expression change?
Mention some types of transformation?
How identifying bottlenecks in various components of informatica and resolving them?
Write the unconnected lookup syntax?
What is joiner transformation in informatica?
What is informatica?
Design time, run time. If you don't create parameter what will happen
expain about the tune parameters?