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
- 19904 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
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain your project of banking domian.
expain about the tune parameters?
draw informatica architecture 8.6 ?
On which transformations you created partitions in your project?
Differentiate between joiner and lookup transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How do you update the records with or without using update strategy?
What is union transformation?
I have a flat file, want to reverse the contents of the flat file
In warehouses how many schemas are there?
What is meant by query override?
Explain dynamic target flat file name generation in informatica
what is Active lock explain
Whats there in global repository
