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
- 27321 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / satish lomte
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,
(i.e. 15000>=10000) 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 (i.e. 22500>=20000), 30,000,(30000>=30000)
and 40,000 rows. (i.e. 37500>=40000 FALSE, so second buffer
is filled after 37500 and commits at 40,0000 )
Also
The writer buffer available depends on the dtm buffer block
size as configured in the session. The default is 64000
bytes. Say for example your target row is 2000 bytes long,
that would mean that each buffer block could hold 32 rows.
If you set your target commit interval at 100 then it would
actually commit at 128 rows. 3 buffer blocks would be 32 x
3 = 96 rows, which is less than the commit interval. 4
buffer blocks would be 32 x 4 = 128 rows.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the advantage of informatica?
What are the types of caches in lookup?
What is a standalone command task?
Briefly define a session task?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to update or delete the rows in a target, which do not have key fields?
Whats there in global repository
Explain what is informatica metadata and where is it stored?
How we can create indexes after completing the loan process?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a rank transform?
How can we use mapping variables in informatica? Where do we use them?
What are the new features of Power Center 5.0?
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 ?
