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
- 20081 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 mapping debugger?
What is difference between a gateway node and worker node?
What is workflow monitor?
What is powercenter on grid?
What are different types of transformations available in informatica?
What is data transformation manager process?
What is data caches/ index caches?
What is a sequence generator transformation?
what is the -ve test case in your project.
Name the different lookup cache(s)?
Explain the etl program with few examples.
What are the tasks that source qualifier perform?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can a transformation be made reusable?
