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
- 39265 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 do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is a stored procedure transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
how we can load rejected record's at run time?(not through bad files)
Describe the impact of several join conditions and join order in a joiner transformation?
wf dont have integration severances how you can run?
Explain the scenario which compels informatica server to reject files?
What is an unconnected transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is union transformation?
what is degenerated dimension?
Which are the different editions of informatica powercenter that are available?
What is the maplet?
What you know about transaction control transformation?
How to create the source and target database connections in server manager?
