1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / rrv

Answers were Sorted based on User's Feedback



You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / benzdev

As per writer buffer here can hold multiple 7500 records
i.e 15000
even though we apply commit points in target the
integration service waits for writter buffer to fill
completely.
Answer is d) 15000,30000,40000

Is This Answer Correct ?    24 Yes 8 No

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / 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

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / vandan

Informatica server issues commit commands as follows as per
your question
15000, 22500, 30000, 37500, 40000

Is This Answer Correct ?    7 Yes 4 No

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / sajj

Target Based Commit

During a target-based commit session, the Informatica Server continues to fill the writer buffer after it reaches the commit interval. When the buffer block is filled, the Informatica Server issues a commit command. As a result, the amount of data committed at the commit point generally exceeds the commit interval.

In above example, 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. Example says multiple buffer so 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. So the Answer is "C"

Is This Answer Correct ?    3 Yes 0 No

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / baby

b

Is This Answer Correct ?    0 Yes 3 No

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / sree

the answer is C

Is This Answer Correct ?    4 Yes 8 No

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 ..

Answer / 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

More Informatica Interview Questions

What is a code page?

0 Answers  

how to create user defined function (udf) in informatica

0 Answers   Informatica,

What is union transformation in informatica?

0 Answers  

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,




I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

what is the -ve test case in your project.

0 Answers   CTS, TCS,

What is a sorter transformation?

0 Answers   Informatica,

What is synonym?

2 Answers   Patni,

What is data caches/ index caches?

0 Answers  

What are the new features of Power Center 5.0?

0 Answers  

For more Informatica Interview Questions Click Here
Categories