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
- 21459 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
what are 3 tech challenges/ common issues you face?
Write the prerequisite tasks to achieve the session partition?
Design time, run time. If you don't create parameter what will happen
Where is metadata stored?
What are batches?
What is the difference between informatica 7.0 and 8.0?
What are the differences between joiner transformation and source qualifier transformation?
How union transformation is used?
What is transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the types of schemas we have in data warehouse.
EXL informatica Questions
Explain what transformation and how many are there in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
