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
- 34051 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / srinu
Joiner :- Catch Performance will work based on
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)
No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.
Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).
Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Explain the different kinds of facts.
How can we handle two sessions in informatica?
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.
As union transformation gives UNION ALL output, how you will get the UNION output?
Briefly define reusable transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Target increases every day even though no new record was inserted
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain transaction control transformation in informatica
What is a sequence generator transformation?
What is the difference between router and filter?
What are the new features of informatica 9.x at the developer level?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
State the differences between sql override and lookup override?
What is confirmed fact in dataware housing?
