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
- 9665 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
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the difference between Active and Passive transformation?
How can you generate reports in informatica?
What are active and passive transformations?
What is status code in informatica?
difference between repository database and repository service?
what is song in infrmatica...?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the components of the workflow manager?
How many ways a relational source definition can be updated and what are they?
Where do we use mapping variables in informatica?
What is joiner transformation?
How many input parameters can exist in an unconnected lookup?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
