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
- 11777 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 sq transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Which are the different editions of informatica powercenter that are available?
How does the aggregator transformation handle null values?
What are the main features of Oracle 8i with context to datawarehouse?
What is a stored procedure transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is the maplet?
What is data transformation manager process?
What is the function of aggregator transformation?
Explain the types of transformations?
can anyone explain me about retail domain project in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What happens when a session fails and you click on recover?
What are multi-group transformations?
