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
- 19663 Views
- HG, UST, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / moorthy g
The Integration Service(IS) reads data from master table
and build data cahe and data index for building cache.
After that read data from detail table perform joins. bcz
routine will be very less(master means very less record
compared to detail table).
Finaly time saving. performance incresing.
| Is This Answer Correct ? | 1 Yes | 1 No |
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
How might one distinguish in the case of mapping is right or not without associating session?
What are the data movement modes in informatica?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What is the difference between view and materialised view?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
how to insert header after each group.
waht type of interface is used for testing the data in informatica
can we use mapplet as starting n ending object in mapping
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
in which situations do u go for sequence generator ?
What's the layout of parameter file (what does a parameter file contain?)?
Teradata 
