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
- 12252 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 are the different versions of informatica?
explan ur project architecture?
Where do we use mapping variables in informatica?
Is there any target staging area in informatica not staging area
What do mean by local and global repository?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Does an informatica transformation support only aggregate expressions?
tell me the rules and responsblites in our project(my project is development)
Can informatica load heterogeneous targets from heterogeneous sources?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain Dataware house architecture .how data flow from intial to end?
what are 3 tech challenges/ common issues you face?
How to open an older version of an object in the workspace?
Difference between Target-based loading and constraint-based loading?
How to join three sources using joiner? Explain though mapping flow.
