Skip to main content
Question

SQL executor working principle

  • March 6, 2024
  • 1 reply
  • 81 views
harish
Contributor
Forum|alt.badge.img+11

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. 

Harish

1 reply

nampreetatsafe
Safer
Forum|alt.badge.img+14

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:

 

Community Stats

32,750
Posts
124,201
Replies
41,252
Members
Terms & ConditionsAccessibility statement
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.