Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21619 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rampriya
Joiner is faster than lookup. Joiner will fetch the data
only once form the database, but the lookup will fetch the
data for each record from the database. So performance wise
joiner is better than lookup.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
what is SDLC way of code development?
What is olap (on-line analytical processing?
Explain in detail about scd type 1 through mapping.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the main issues while working with flat files as source and as targets ?
What is the session task and command task?
How we can create indexes after completing the load process?
What is the cumulative sum and moving sum?
What is lookup transformation?
Parameter and variable differences
What is difference between a gateway node and worker node?
What is a dimensional model?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the Rank index port in Rank transformation?
