Yes! talend has save point but, those are not like database save point. it is used to restart a job from where it failed. It is also called as "Restart Functionality or ability", if job fails in the middle of execution. this is not available in Open Studio.
you are asking about transaction? if yes then you have to use three database components as below.
First Open connection using tOracleConnection ( you can use relevant database) Then use your oprations like insert, update delete using tOracleInput and output component. at last on sub job ok use tOracleCommit. to commit the changes. you final job should look like below.
tOracleConnection | OnComponentOk | tOracleInput---tMap---tOracleOutput ( use connection option instead configuring at component level) | OnSubJobOk | tOracleCommit
Save point functionality available in enterprise version and you have to configure it using TAC.
You can use bulk component, to load the data faster, also you can do some optimisation for input component.
Select only required columns, If it is oracle then select cursors options in the advance tab of component, it will be faster than current process. use bulk load component for data load. ( it requires loader to be installed on machine where job runs) Load data in chunks, by applying filters on select statement. Add more memory on current hardware so job can utilizes it for better performance.
it is just a check box on job tab beside the context tab, go there you will see another settings among them click on "extra"-->select "multi threading execution" option. Not required anything else. it will help you to execute your job using threading.