Does DBSCD components require a commit ?

mobmsc2 — Fri, 15 Nov 2024 23:02:22 GMT

When carrying out ELT and using the tDBSCD to handle slowly changing dimensions do I need a separate commit the open connection or is there a way to confirm the component to handle commit as needed?

Re: Does DBSCD components require a commit ?

Anonymous — Fri, 08 Apr 2022 04:34:36 GMT

Hello,

If I understand your requirement very well, are you use the “commit N” capability (setting a commit interval) when you use the Talend DB ELT components? If so, this capability is not there in the ELT components.

You could write a custom PL/SQL script as a SQL pattern the has a cursor and does commit after x number of rows. In general ELT script don't use commit point, because you ROLLBACK operation in case of Error.

Best regards

Sabrina

topic Does DBSCD components require a commit ? in Talend Studio

Does DBSCD components require a commit ?

Re: Does DBSCD components require a commit ?