Using an Oracle sequence while inserting data

You can genarate automatically primary key values while inserting data, using the sequence defined in Oracle.

In Talend Studio, the sequence is used in the Additional columns table, in the Advanced settings tab of the tOracleOutput component. Additional Columns are designed to handle DB columns which need DB SQL instructions.