Interested to Buy Any Domain ? << Click Here >> for more details...
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
- 21 Answers
- 40069 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / ajay bhosal
Uncached lookup can give you good performance here but only when your target is properly indexed. Moreover, it's not a good idea to hit the database 100 times and scan huge data volume in the database.
Similar or better performance can be achieved by using Joiner with Sorted Input, but ensure that 100 rows are in master pipeline and the detail pipeline is sorted.
There is no question of using cached lookup.
Answer will be Joiner.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How union transformation is used?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Repository user profiles
Mention some types of transformation?
what is the size of u r source(like file or table)?
How do you load alternate records into different tables through mapping flow?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why update strategy and union transformations are active?
In which transformation you cannot drag ports into it?
what are 3 tech challenges/ common issues you face?
What is the format of informatica objects in a repository?
Is there any way to read the ms excel datas directly into informatica?
Separate from a database, an information bazaar, and an information stockroom?
Explain how many types of dimensions are available in informatica?
