Interested to Buy Any Domain ? << Click Here >> for more details...
Why we select the table which has minimum number of records
as Master table in joiner?
- 4 Answers
- 20080 Views
- HG, UST, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Its preferable to create your smaller table to be master because
1.Size issue Informatica will create index and data cache.
2.More logical lets say your master table contains 10 rows and your detailed table contains 1000 rows so each of your source rows just have to check against 10 of master rows and thus its faster wile if you take it viceversa than each of your source table hast to go against 1000 rows and it ll hot performance issue This is just a small example check with real scenario and you ll came to know.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
Explain the code page compatibility?
Different circumstance which drives informatica server to expel records?
What will be the approach?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How many ways a relational source definition can be updated and what are they?
Define Pmrep command?
What does update strategy mean, and what are the different option of it?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is main use of mapplet?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the need for an etl tool?
What is pmcmd command?
4 yrs etl devloper roles and responsibilities?any body give solutions
Write the unconnected lookup syntax?
