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
- 27129 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 is dimensional table? Explain the different dimensions.
How to Create a folder using pmrep command?
difference between repository database and repository service?
How can informatica be used for an organization?
What is mapplet in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the types of data warehouses?
How to handle decimal places while importing a flatfile into informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What all are steps in up gradation of Informatica server?
How does a rank transform differ from aggregator transform functions max and min?
Define joiner transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is repository manager?
