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
- 40065 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
How can you define user defied event?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Define mapping and session?
Which transformation should we use to normalise the COBOL and relational sources?
What is the command used to run a batch?
Which is the t/r that builts only single cache memory?
Explain pushdown optimization $pushdownconfig parameter - informatica
What the difference is between a database, a data warehouse and a data mart?
What is pmcmd command?
Tell me about Propagate functions in informatica
Differences between connected and unconnected lookup?
Write the prerequisite tasks to achieve the session partition?
State the limitations where we cannot use joiner in the mapping pipeline?
Describe an informatica powercenter?
What is informatica?
