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
- 19877 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
Could you explain what is enterprise data warehouse?
What is complex mapping?
Explain dynamic target flat file name generation in informatica
Can we create multiple integration service on single repository?
How can we use mapping variables in informatica? Where do we use them?
waht type of interface is used for testing the data in informatica
what is the difference between informatica6.1 and infomatica7.1
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is blocking transformation?
What is the function of union transformation?
Performance tuning in UNIX for informatica mappings?
Define pmcmd command?
What is the use of code page?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to partition the Session?
