Why we select the table which has minimum number of records
as Master table in joiner?
- 4 Answers
- 18018 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 |
why we use stored procedure transformation?
what is the process we used in joiner transformation,there is no matching column in sources?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
performance tuning of Informatica
How to use pmcmd utility command?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
what is metadata?
What are active transformations.
what is data driven?
explain different types of modeling.
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
what is the hint? how to use it to reduce the query processing in program?
Teradata 
