Data caching - Commiting data batch wise

dsdeveloper123 · Post by **dsdeveloper123** » Fri Sep 14, 2007 1:36 am

Hi,

I have to insert close to 10lakh into oracle database. The datastage caches all 10 lakh records and then inserts and performs a commit ....

Now what I wanna do is that , the insertion should happen for very 1 lakh records and a COMMIT should be performed at this stage ...

Kindly let me know if there is any solution asap.

Cheers!

Mayur Dongaonkar · Post by **Mayur Dongaonkar** » Fri Sep 14, 2007 5:56 am

You have to set arraysize = 1 L and commit size = 1 L option.

dsdeveloper123 · Post by **dsdeveloper123** » Fri Sep 14, 2007 6:04 am

Arraysize = 1 L and commit size = 1 L option or found only in Oracle OCI stage (i.e server jobs)

Can u please guide me how do I handle the same with server Jobs

ray.wurlod · Post by **ray.wurlod** » Fri Sep 14, 2007 2:58 pm

Make up your mind. You posted in the parallel forum with a job type marked as parallel. Now, you ask for a server answer. To get that, post your question in the server forum.

DSXchange

Data caching - Commiting data batch wise

Data caching - Commiting data batch wise

Re: Data caching - Commiting data batch wise