Interested to Buy Any Domain ? << Click Here >> for more details...
which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 12079 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pawan
R u looking for flat or database file?
Generally sorted joiner more effective on flat files than lookup, because sorted joiner uses merge join and cache less rows. Lookup caches always whole file. If the file is not sorted, it can be comparable. Lookups into DB table can be effective if the DB can return sorted data fast and the amount of data is small, because lookup can create whole cache in memory. If DB responses slowly or big amt of data r processed, lookup cache initialization can be really slow.
Then it can be better use sorted joiner, which throws data to output as reads them on input.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is informatica?
Name the different lookup cache(s)?
Explain load alternative records / rows into multiple targets - informatica
What is informatica metadata and where is it stored?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the advantage of informatica?
What are the differences between source qualifier and joiner transformation?
What is an Integration service in Informatica?
expain about the tune parameters?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the meaning of up gradation of repository?
Informatica settings are available in which file?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Enlist the advantages of informatica.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
