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
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
difference between informatica 8.1.1 and 8.6
How many number of sessions can one group in batches?
What is the cumulative sum and moving sum?
What is rank transform?
What is the format of informatica objects in a repository?
What is resilience time?
Describe an informatica powercenter?
How many ways are there to do 'remove duplicate records in informatica'?
What are the different types of repositories created using informatica?
How you can differentiate between connected lookup and unconnected lookup?
What you know about transaction control transformation?
Repository user profiles
What are the limitations of joiner transformation?
Explain what transformation and how many are there in informatica?