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
- 27339 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 is the cumulative sum and moving sum?
What is event and what are the tasks related to it?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How can you differentiate between powercenter and power map?
What is source qualifier transformation in informatica?
How can we store previous session logs?
Difference between Data and Index Caches?
What is decode in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is workflow? What are the components of the workflow manager?
What is domain in terms of informatica?
Write the different tools in the workflow manager?
Explain load alternative records / rows into multiple targets - informatica
What are mapplets?
What is meant by lookup transformation?
