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
- 27373 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / nagesh
Ans (C)
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. 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.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are session parameters ? How do you set them?
Which development components of informatica have the highest usage?
What is xml source qualifier transformation in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is lookup change?
Sequence generator, when you move from develoment to production how will you reset
How to generate sequence numbers?
What if the source is a flat-file?
What are the databases that informatica can connect to windows?
Can we override a native sql query within informatica?
What is a standalone command task?
Why sorter is an active transformation?
What are the different options available for update strategy?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
