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
wf dont have integration severances how you can run?
Define enterprise data warehousing?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the Process to creating lookup transformation in informatica
what is $$$$?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are active and passive transformations?
How to configure mapping in informatica?
What is a pre-defined event and user-defined event?
What are the differences between joiner transformation and source qualifier transformation?
How we can use union transformation?
Briefly define a session task?
What are the modules in Power Center
What is rank transform?