Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 27102 Views
- Deloitte, I also Faced
- E-Mail Answers
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
What is the difference between a connected look up and unconnected lookup?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain joiner transformation in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a sequence generator transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Is it possible to revert a global repository to local one and why?
In how many ways we can create ports?
Why do we need informatica?
How to elaborate tracing level?
What is the difference between STOP and ABORT options in Workflow Monitor?
Parameter and variable differences
Explain direct and indirect flat file loading (source file type) - informatica
Explain lookup transformation source types in informatica
What is union transformation?
