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 / jaybrata
Unless you want to join in Database, the only option considering performance is - USE NO CACHE.
BUT, you have to have proper index defined on your target database table, this is crucial as otherwise there will be 100 full table scans on 5 million records.
Static Cache is the worst option as it will always cache 5 million records just to compare 100 records.
Dynamic cache is not an option assuming 100 source records do not contain duplicate.
Informatica side joining is also not good, better to join in DB side instead (To know why and to check the comparison between Infa side and DB side joins, check www.dwbiconcepts.com)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is substr in informatica?
How can we use batches?
Can anyone tell me the new features in Informatica 9 Version?
Difference between Data and Index Caches?
What is a sequence generator transformation?
How will the document be delivered to me?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Which version configuration tool used in ur project?
What is meant by query override?
what is song in infrmatica...?
How might one distinguish in the case of mapping is right or not without associating session?
Enterprise data warehouse your projects phase by phase explain?
What is a pre-defined event and user-defined event?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the difference between informatica 7.0 and 8.0?