[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.