[resolved] Updating staging table After successful database operation

Five Stars

[resolved] Updating staging table After successful database operation

Hi
I am new to Talend and was hoping someone could provide me a solution for the following
To process my data - i first load the data into a staging table which has a status column, error message column. The intention here is to record the status of the data operation and log the error message.
My question is that after the database operation completes - i have success records and rejects and i need to according update the staging table via a stored procedure. However how do i pass the primary key of the staging table to the stored procedure task from the main database insert task. The main table has no idea about the staging or its schema.
The screen shot below might make it more clear.

Accepted Solutions
Four Stars

Re: [resolved] Updating staging table After successful database operation

Hi Siddharth,
You can add one more output and connect it to your stored procedure.
Vaibhav

All Replies
Four Stars

Re: [resolved] Updating staging table After successful database operation

Hi Siddharth,
You can add one more output and connect it to your stored procedure.
Vaibhav