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
- 27056 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
Explain the different lookup methods used in informatica?
What are the limitations of joiner transformation?
What is lookup change?
What are the different transaction levels available in transaction control transformation?
What is persistent lookup cache?
How many dimensions are there in informatica?
What is union transformation in informatica?
Explain in detail scd type 2 through mapping.
What are the uses of etl tools?
What is a standalone command task?
Is it possible to create multiple domains on a single Informatica server?
What are the types of lookup transformation?
What are the tuning techniques you applied during your last project
How to load a Dimension ? and how to load a fact table?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
