DSXchange

Hi...i am inserting rows into oracle table using upsert mode. The job is showing the number of rows it is processing from input to output , but when i see through toad in the table i am not seeing any rows inserted? My job is

dataset---->oracle enterprise stage

Can any one let me know the reason for it?

Add a reject link to your oracle stage and see if any links go down that path.

All the monitor shows is how many records were sent down the link to the database, it is not an indication of how many were successful.

i am running same kind of jobs for around 7 tables and all of them are showing like that and there are no rows in the reject link till now

Just a hunch, but were all the records you processed updating records at target? Or do you have zero rows at target?

actually there are no rows before in this table. I have truncated all of them and trying to insert new rows.

I tried to insert a row at the database level through sqlplus and it is working and i dont know whats the problem with datastage not able to insert

but when i see from toad it is still not showing the row that i inserted but at sqlplus i am able to see it and the rowcount as 1. In toad rowcount is 0

So having run through Datastage, you can see a row was inserted (when using sqlplus) but in Toad you can't see it then. Your issue lies with how Toad is viewing data then I imagine - maybe Toad is looking at a different schema or something? Certainly sounds like Datastage is doing its job from your last description. I haven't got Toad here I'm afraid and it's been a good few years since I did use it, so I can't help any more on the specifics of that I'm afraid.

You probably have a filter condition set in Toad, if you are looking via the Schema Browser.

i am using upsert option. does the insert starts immediately inserting the rows. bcoz...my job ran for 2hrs and aborted in the middle due to connection failure and non of the rows are inserted. What could be the reason for this?

How often are you committing changes?

i used time and row interval (ora_upsert) as 1 million (1000000).

Someone mentioned for you to create a reject link off the Oracle Stage so that you can see if there rejecting vs. actually loading.....I agree bet there rejecting....

Someone mentioned for you to create a reject link off the Oracle Stage so that you can see if there rejecting vs. actually loading.....I agree bet there rejecting....