• EN
Question

SQL executor working principle

  • 6 March 2024
  • 1 reply
  • 23 views
harish
Rank
Badge +6

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
Rank
Userlevel 1
Badge +10

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

28,823
Posts
109,858
Replies
36,638
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.