Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 10620 Views
- CGI, I also Faced
- E-Mail Answers
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the mapping parameters and mapping variables?
What is decode in informatica?
What does update strategy mean, and what are the different option of it?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
how tokens will generate?
how to create user defined function (udf) in informatica
How do you promote a non-reusable transformation to reusable transformation?
I have a flat file, want to reverse the contents of the flat file
Informatica Checkpoints
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Can we create two repositories on same database instance in oracle?
What is DR strategy for Informatica project?
What is the difference between informatics 7x and 8x and what is latest version?
What are the restrictions of union transformation?
