Skip to main content
  • EN

I am using Oracle DB. My sql commands are update commands. I believe it is directly sending to the oracle to execute rather than regular transformer which execute in batches. Please clarify. 

Hi @harish: I just want to clarify that you’re talking about having your Oracle Writer feature type set to Update, and are asking how that is handled?  Or are you using a SQLExecutor?

If it’s the Writer that you’re using, than yes it’s making the updates directly through SQL calls to your Oracle database.  However, you can set the batch and transaction sizes in the Writer parameters:

 

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.