Purpose of the 'Array Size' and 'Transaction size' in OCI

ratuldey · Post by **ratuldey** » Fri Aug 17, 2007 3:49 pm

Hi,

Please explain what does the "Array size' and "Transaction size" fields used for in case of Orcale OCI stage used as the Target stage. What does the values assigned to them signify and change the job run properties?

I would also like to know whether the "Transaction size" and "Rows per transaction" have anything in common for the Oracle target stage in a DS job?

Thanks.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 17, 2007 4:28 pm

Have you searched the forum? Both your questions have been answered previously.
When an OCI stage has an input link Array size is the number of rows sent to Oracle at a time.
Transaction size and rows/transaction are the number of rows sent before a COMMIT is sent. One of them (I can't remember which) has been deprecated in favour of the other. Your search will confirm which it is.

chulett · Post by **chulett** » Fri Aug 17, 2007 4:37 pm

I'm sensing a pattern emerging here...

Please take the time to try to help yourself first. Open the OCI stage, switch to the tab you are curious about and then click the 'Help' button. For example, from the Input tab you'll get a help page with explanations for all of the questions you've posted here. And then from there, you should be able to link around to any of the other parts of the stage you are curious about, including the Transaction Handling tab.

We're more than happy to help with specific problems or questions on usage, but are not really here to be a substitute for training.