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
- 27350 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a predefined event?
Where is metadata stored?
What is meant by target load plan?
Explain the informatica workflow?
What do you understand by SOA of Informatica?
What is workflow? What are the components of the workflow manager?
How do you update the records with or without using update strategy?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
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
Design a mapping to load a target table with the following values from the above source?
Differentiate between reusable transformation and mapplet.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
