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
- 27304 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Performance tuning in UNIX for informatica mappings?
What are the new features of Power Center 5.0?
wf dont have integration severances how you can run?
What are the advantages of informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do you mean by channel change?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the uses of etl tools?
What are some examples of informatica etl programs?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the types of transformations?
