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
- 40096 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / amarnath
using the joiner is right I have faced similar kind of
scenario in my project. if u use static it has to cache all
the 5m records and then compare the each incoming records
which will de-grade the performance, hence designate the
master record with less no of rows in joiner which is a gud
practice.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is informatica worklet?
What is meant by target load plan?
what is the size of your data warehousing?
Explain the mapping variable usage example in informatica
In informatica workflow manager, how many repositories can be created?
Sequence generator, when you move from develoment to production how will you reset
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Informatica Checkpoints
Explain the features of connected and unconnected lookup.
what is degenerated dimension?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the reusable transformations?
What is data movement mode in Informatica and difference between them?
what is song in infrmatica...?
