result rows are not showing up-total mismatch

qutesanju · Post by **qutesanju** » Tue Apr 07, 2009 6:31 am

is there any way to load 1 row at a time?

and also if no of keys are increased then i observed more records are getting inserted.

but i can not treat all fields as key fields.

and I added most non null fields as key fields

Sainath.Srinivasan wrote:To solve, you must find the missing rows and the reason why they are being ignored.

You can
a.) clear the 3rd party s/w and insert the 900 rows successfully loaded again.
b.) load 1 row at a time and see which row fails.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 07, 2009 10:08 am

Without seeing your table defn. and dataset it is not feasible to comment.

girija · Post by **girija** » Tue Apr 07, 2009 11:09 am

Define same table in the temporary as your target withh all indexes and constaints on. Try oracle stage to upsert the data into this table . From director log you will found how many rows got inserted and how many rejected or update.

qutesanju · Post by **qutesanju** » Wed Apr 08, 2009 2:56 am

my stored procedure is using data from temp table itself.
and i think i cant use oracle stage to upsert the data as i m using microsoft sql server

girija wrote:Define same table in the temporary as your target withh all indexes and constaints on. Try oracle stage to upsert the data into this table . From director log you will found how many rows got inserted and how many rejected or update.