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
- 25102 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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explian the Process of deployment groups in informatica
Differentiate between a database and data warehouse?
How union transformation is used?
Enlist the various types of transformations.
Is it possible to define a single node as a Gateway node as well as worker node?
What do you mean by blocking transformation?
What is meant by incremental aggregation?
Which are the different editions of informatica powercenter that are available?
What are the different transaction levels available in transaction control transformation?
What all are steps in up gradation of Informatica server?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is workflow? What are the components of workflow manager?
Differentiate between joiner and lookup transformation?
