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
- 33915 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
Explain the scenario which compels informatica server to reject files?
How many ways a relational source definition can be updated and what are they?
What is depict expression change?
What is an Integration service in Informatica?
How can we improve session performance in aggregator transformation?
Enlist the differences between database and data warehouse.
According to his methodology what all you need before you build a datawarehouse
What is the maplet?
Define filter transformation?
What do you understand by a term domain?
What are multi-group transformations?
Define Pmrep command?
What you know about transaction control transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
