Performance wise which is better joiner or look up ?
Give me with example?
Answer Posted / abhinaw prakash
There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
What is parallel processing in informatica?
How to update source definition?
What is workflow manager?
How can we use batches?
What is the difference between router and filter?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the different clients of powercenter?
What are the new features of informatica 9.x developer?
can anyone explain me about retail domain project in informatica?
Separate from an archive server and a powerhouse?
How can you increase the performance in joiner transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
wat are deployement groups in informatica, how it will be used for developers
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?