DSXchange

hi all,

I am using the dataset created from prior joba and inserting the records using the oracle stage with user defined SQL with write method as upsert.In datastge direction monitor tab,it shows the records are inserted .but when i query in database by select ,unable to find records.Could you please help out to reslove the issue.

Thanks in advance

Loads of possibilities. You need to provide more information on what you are trying.

Maybe you are checking the wrong table (or database).

Or the records going as update with no change.

Or the records are rejected.

Or one of other possible scenarios.

No, the monitor shows the number of requests sent to the database. Your job's log detail should show any issues it had fulfilling those requests.