performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / venubyna1
Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the informatica workflow?
what is size of u r database?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are session parameters ? How do you set them?
What is native users?
What are the different types of olap? Give an example?
What all join we can perform in LOOKUP transformation?
Enlist the differences between database and data warehouse.
What is a shortcut and copy in Informatica and how two are different with each other?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
draw informatica architecture 8.6 ?
What will be the approach?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to load a Dimension ? and how to load a fact table?
How can we delete duplicate rows from flat files?