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
- 40063 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 are the guidelines to be followed while using union transformation?
What is lookup change?
What is dimensional table?
Repository user profiles
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
design of staging area?
Enlist some properties of sessions.
What is blocking transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain constraint based loading in informatica
What are the advantages of using informatica as an etl tool over teradata?
Explain your project of banking domian.
How would you copy the content of one repository to another repository?
Different circumstance which drives informatica server to expel records?
what is SDLC way of code development?
