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 is plsql table?
what is fact table?
what is the look up transformation?
How to generate a single mapping for both the historical and incremental load.
can we generate reports in informatica ? How?
What is intricate mapping?
difference between stop and abort
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
can you use flat file for lookup table?why?
What is the term PIPELINE in informatica ?
What is hash partition?
Can you access a repository created in previous version of Informatica?