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
Partition, what happens if the specified key range is shorter and longer
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is native users?
how to load dimension table and fact table. plz tell me the steps.
What is blocking transformation?
What is an expression transformation?
Have you worked with/created Parameter file
How might one distinguish in the case of mapping is right or not without associating session?
scenario where i can use only concurrent execution of workflow.
What are the modules in Power Center
r u done any partitions in ur project?
How can we use batches?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is dimensional table? Explain the different dimensions.
What is persistent lookup cache?