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?
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.
