Interested to Buy Any Domain ? << Click Here >> for more details...
Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 11381 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
What is the procedure for creating independent data marts from informatica 7.1?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the uses of etl tools?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the different lookup cache(s)?
What is session task and command task?
Explain what is informatica metadata and where is it stored?
What will be the approach?
Partition, what happens if the specified key range is shorter and longer
permutations of mapplet
How can we delete duplicate rows from flat files?
Performance tuning in UNIX for informatica mappings?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
what is the Default Source Option For Update Strategy Transformation?
