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 / sajj
Target Based Commit
During a target-based commit session, the Informatica Server continues to fill the writer buffer after it reaches the commit interval. When the buffer block is filled, the Informatica Server issues a commit command. As a result, the amount of data committed at the commit point generally exceeds the commit interval.
In above example, a session is configured with target-based commit interval of 10,000. The writer buffers fill every 7,500 rows. When the Informatica Server reaches the commit interval of 10,000, it continues processing data until the writer buffer is filled. Example says multiple buffer so the second buffer fills at 15,000 rows, and the Informatica Server issues a commit to the target. If the
session completes successfully, the Informatica Server issues commits after 15,000, 22,500, 30,000, and 40,000 rows. So the Answer is "C"
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the tasks that can be performed using sq?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can you increase the performance in joiner transformation?
What are the performance considerations when working with aggregator transformation?
Briefly define a session task?
Explain sessions?
What is a difference between complete, stop and abort?
lookup transformation with screenshots
What is informatica?
Mention few advantages of router transformation over filter transformation.
Whats the difference between informatica powercenter server, repositoryserver and repository?
Clarify the aggregator change?
what is the hint? how to use it to reduce the query processing in program?