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
- 19906 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
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Quickly characterize reusable change?
what are the deliverables?in your project?
How to Create a folder using pmrep command?
What do you understand by SOA of Informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
In warehouses how many schemas are there?
Why is sorter an active transformation?
What differs when we choose the sorted input for aggregator transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Can anyone tell me the new features in Informatica 9 Version?
Is it possible to revert a global repository to local one and why?
What is event and what are the tasks related to it?
