Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21458 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rampriya
Joiner is faster than lookup. Joiner will fetch the data
only once form the database, but the lookup will fetch the
data for each record from the database. So performance wise
joiner is better than lookup.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Mention few advantages of router transformation over filter transformation.
Whats there in global repository
How to load a Dimension ? and how to load a fact table?
How can we delete duplicate rows from flat files?
Enlist the advantages of informatica.
Is it possible to revert a global repository to local one and why?
Please let me know how to make encryption and decryption with example?
What is a standalone command task?
How do you handle two sessions in Informatica
What is the difference between source qualifier transformations source filter to filter transformation?
How to load the data from people soft hrm to people soft erm using informatica?
what are the Methods For Creating Reusable Transformations?
What is an aggregator transformation?
