Skip to main content
Question

SQL executor working principle

  • March 6, 2024
  • 1 reply
  • 45 views

harish
Contributor
Forum|alt.badge.img+10

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. 

1 reply

nampreetatsafe
Safer
Forum|alt.badge.img+12

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings