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
- 34133 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
How to extract the informatica rejected data?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to convert multiple rows to single row (multiple columns) in informatica
How do you load unique records into one target table and duplicate records into a different target table?
I have a flat file, want to reverse the contents of the flat file
How an expression transformation differs from aggregator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is repository manager?
what is $$$$?
Explain transaction control transformation in informatica
Which are the different editions of informatica powercenter that are available?
What are the main features of Oracle 8i with context to datawarehouse?
permutations of mapplet
Explain your project of banking domian.
