tOracleOutput

[MZein]

Hi,

I Have a job and I need to retrieve all the newly created records in my DB table i.e all inserted records in the DB table

could you please advise me if there are methods to get back all my newly inserted Records. by the way the data are inserted in the table and the primary key of that table is auto incremented key

Best Regards 

[Anonymous]

Hi MZein,

First do the full load to the target.

Then, take the max(ID) (primarykey) from output table and store it into the context variable.

Apply where clause in inputDB component like where ID>context.max while inserting the data to output table.

Thanks.

[manodwhb]

@MZein , if you are have any column like create date while inserting the data into table.then you can try to extract based on that date column.

[MZein · Accepted solution]

Thank you for your interaction with my problem

I found a solution to it. By using tMap and save data that has a null joint key (new data)

Tahnks a lot again