Performance wise which is better joiner or look up ?
Give me with example?
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 |
What are set operators in Oracle
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Using Connected or unconnected lookup for performance wise which one is preferable?.
Plz..let me know differences between Informatica 7.1 and 8.1?
Could you explain what is enterprise data warehouse?
What is the need of etl tools?
What is a shortcut and copy in Informatica and how two are different with each other?
Define maping and sessions?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
how to duplicates from expression transformation without using sorter before that
what is session override?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?