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
- 19868 Views
- HG, UST, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is transformation?
What are the transformations that are not supported in mapplet?
Implementation methodology
What is the meaning of decode in informatica?
difference between informatica 8.1.1 and 8.6
What you know about transaction control transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is lookup change?
What are the new features of informatica 9.x in developer level?
How can one identify whether mapping is correct or not without connecting session?
What is rank transformation?
What is a standalone command task?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Whats there in global repository
What are the various types of transformation?
