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
- 33900 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 ? | 27 Yes | 3 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
Design a mapping to load a target table with the following values from the above source?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What will be the approach?
How might you approve all mappings in the archive all the while?
What is decode in informatica?
What is blocking transformation?
Which are the different editions of informatica powercenter that are available?
differences between service based and product based?
what is the size of u r source(like file or table)?
Quickly characterize reusable change?
What is a joiner transformation?
What are the different options available for update strategy?
