Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 40669 Views
- Deloitte, I also Faced
- E-Mail Answers
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 INFORMATICA TESTING process
What are the types of data warehouses?
draw informatica architecture 8.6 ?
Explain direct and indirect flat file loading (source file type) - informatica
What are mapplets? How is it different from a Reusable Transformation?
Explain what are the different versions of informatica?
What are the main issues while working with flat files as source and as targets ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Is it possible to create multiple domains on a single Informatica server?
Please let me know how to make Data masking in informatica..
What is pmcmd command?
In how many ways we can create ports?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is informatica etl tool?
