performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 20138 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 DR strategy for Informatica project?
What are the advantages of informatica?
what is mean by complex business rule ?
As union transformation gives UNION ALL output, how you will get the UNION output?
In how many ways we can create ports?
What is the surrogate key?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to Create a folder using pmrep command?
Why sorter is an active transformation?
Can anyone tell me the new features in Informatica 9 Version?
What are the features of complex mapping?
What is the format of informatica objects in a repository?
Where is metadata stored?
Informatica settings are available in which file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
