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
- 39251 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / coolboy
Hi,
Here we will use joiner for better performance.We will join
the two sources making source table as master source.so
only 100 comparisons will be done.So it will be very faster.
Whereas in static and dynamic we have to look up on the
target which is very large 5m rows.So caching will take
more time.
| Is This Answer Correct ? | 28 Yes | 3 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
How to open an older version of an object in the workspace?
How can you generate reports in informatica?
How you prepared reports for OLAP?
what is the complex transformation you used in informatica
What is union transformation?
How does a sorter cache works?
What is a grid in Informatica?
What is the need for an etl tool?
How might one distinguish in the case of mapping is right or not without associating session?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How we can create indexes after completing the loan process?
What is an unconnected transformation?
Explain scd type 3 through mapping.
Is it possible to create multiple domains on a single Informatica server?
