issue with oracle

nani0907 · Post by **nani0907** » Thu Dec 17, 2009 8:00 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Dec 17, 2009 8:15 am

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.

chulett · Post by **chulett** » Thu Dec 17, 2009 9:28 am

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.