unable to see the data after inserting

kirankota79 · Post by **kirankota79** » Wed Jul 23, 2008 7:36 am

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?

ArndW · Post by **ArndW** » Wed Jul 23, 2008 7:49 am

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

chulett · Post by **chulett** » Wed Jul 23, 2008 7:54 am

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.

kirankota79 · Post by **kirankota79** » Wed Jul 23, 2008 7:57 am

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

miwinter · Post by **miwinter** » Wed Jul 23, 2008 8:45 am

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

kirankota79 · Post by **kirankota79** » Wed Jul 23, 2008 9:00 am

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

miwinter · Post by **miwinter** » Wed Jul 23, 2008 9:17 am

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.

chulett · Post by **chulett** » Wed Jul 23, 2008 9:39 am

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

kirankota79 · Post by **kirankota79** » Wed Jul 23, 2008 1:07 pm

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?

chulett · Post by **chulett** » Wed Jul 23, 2008 1:15 pm

How often are you committing changes?

kirankota79 · Post by **kirankota79** » Wed Jul 23, 2008 1:20 pm

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

trokosz · Post by **trokosz** » Wed Jul 23, 2008 7:13 pm

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

trokosz · Post by **trokosz** » Wed Jul 23, 2008 7:14 pm

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