Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 9676 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil
Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..
If anything wrong pls let me know...am looking for job..
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
tell me about your project functionality
Reusable transformation and shortcut differences
Where can we find the throughput option in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a transaction control transformation?
Enlist few areas or real-time situations where informatica is required.
What is the maplet?
What are the new features of informatica 9.x at the developer level?
What is the function of union transformation?
Is it possible to revert a global repository to local one and why?
How an expression transformation differs from aggregator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Which is the t/r that builts only single cache memory?
How to configure mapping in informatica?
what is song in infrmatica...?
