Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 10621 Views
- CGI, I also Faced
- E-Mail Answers
Answer / 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 |
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
What are the components of Informatica? And what is the purpose of each?
why union transformation is active transformation?
what are types of dimentions?
How u use pdf file in informatica source?
why union is active transformation?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
Differences between connected and unconnected lookup?
What is the scenario which compels informatica server to reject files?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
How can repository reports be accessed without sql or other transformations?
Teradata 
