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 / kareem
we need to use dynamic lookup because when 110 rows are
coming from the source and 5 m rows are already existing in
the target here the function of the dynamic lookup is used
to share the source rows and insert into the target.
Hope answer your question.
Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Differentiate between reusable transformation and mapplet.
Explain what are the different types of transformation available in informatica.
How to join three sources using joiner? Explain though mapping flow.
What is data transformation manager process?
What is a code page?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain the difference between a data warehouse and a data mart?
Differentiate between a database and data warehouse?
How identifying bottlenecks in various components of informatica and resolving them?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Please let me know how to make Data masking in informatica..
Why sorter is an active transformation?