Save point in Talend

[Anonymous]

can Talend provide save point type mechanism or not?

[Anonymous]

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. 

[Anonymous]

how we can implement this mechanism of save point.
i want that if any error come my whole jobs effect should be rollback also from database.

[Anonymous]

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. 

[Anonymous]

thanks.
But it slow down my jobs performance.
16 Lac records transfer in 48 minutes which is very slow can u have any idea about it.

[Anonymous]

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. 
  
 

[Anonymous]

i want to transfer data from oracle input table to oracle output table so i cannot use Bulk load component.
I Implement first 2 points that is given by you.
but still it take 35 to 40 min.

[Anonymous]

Use multi threading option from job tab.

[Anonymous]

how this help to me?

[Anonymous]

how this help to me?
I want to transfer all records.
i don't know how to use it and how it work.
can u please tell me how i can use it