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


Please Help Members By Posting Answers For Below Questions

wf dont have integration severances how you can run?

1547


Define enterprise data warehousing?

642


What are the basic requirements to join two sources in a source qualifier transformation using default join?

625


What is the Process to creating lookup transformation in informatica

593


what is $$$$?

1748






complex mapping ur project u r invlve can u explain and give real time example give me ?

1854


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

706


What are active and passive transformations?

658


How to configure mapping in informatica?

688


What is a pre-defined event and user-defined event?

587


What are the differences between joiner transformation and source qualifier transformation?

636


How we can use union transformation?

622


Briefly define a session task?

599


What are the modules in Power Center

1246


What is rank transform?

611