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

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


Please Help Members By Posting Answers For Below Questions

Explain informatica architecture - version 8 / 9

673

What are the restrictions of union transformation?

582

What are the various types of transformation?

646

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1690

Can we create multiple integration service on single repository?

705




In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5267

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1922

Separate from a database, an information bazaar, and an information stockroom?

611

What is a dimensional model?

584

What is a rank transform?

678

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1520

What is intricate mapping?

594

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6094

can we override a native sql query within informatica? Where do we do it? How do we do it?

601

What are the different types of repositories created using informatica?

663