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
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
Define update strategy?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain the types of transformations?
What is intricate mapping?
pmscmd startworkflow -sv
What is lookup transformation?
What are the types of caches in lookup? Explain them.
How big was your fact table
Explain dynamic target flat file name generation in informatica
What are the different types of olap? Give an example?
What all are steps in up gradation of Informatica server?
Plz can any one say me how to get the informatica certification materials and dumps
What is the procedure for creating independent data marts from informatica 7.1?
What is a pre-defined event and user-defined event?
Design a mapping to load the cumulative sum of salaries of employees into target table?