You have defined the following:
- Commit Type = 'Target'
- Commit Interval = 10000
- writer buffer block can hold multiple 7,500 rows
- you are loading 40,000 records into the target
After how many records will the Informatica Server issue
commit commands?
a)7500, 15000, 22500, 30000, 40000
b)15000, 22500, 30000, 37500, 40000
c)15000, 22500, 30000, 40000
d)15000, 30000, 40000
Answer Posted / benzdev
As per writer buffer here can hold multiple 7500 records
i.e 15000
even though we apply commit points in target the
integration service waits for writter buffer to fill
completely.
Answer is d) 15000,30000,40000
| Is This Answer Correct ? | 24 Yes | 8 No |
Post New Answer View All Answers
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to differentiate between the active and passive transformations?
What is rank transformation?
How can you generate reports in informatica?
How would you join a node to the already existing domain?
Define enterprise data warehousing?
COM components can be used in Informatica
Briefly define a session task?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is an unconnected transformation?
What do you mean by channel change?
In informatica workflow manager, how many repositories can be created?
What is data movement mode in Informatica and difference between them?
What is Session and Batches?
difference between informatica 8.1.1 and 8.6