Row count not matching between DS and toad

dsuser_cai · Post by **dsuser_cai** » Tue Jul 28, 2009 4:51 pm

Hi

I have a server job that reads data from Oracle DB. when I run the job the job gives me 15994 records (i mean the job extracts only 15994 records), but when i runt he same query in toad it gives me 16018 recods. i checked the job in director, it dosent have any warning in it. i do not see any problem while the job runs.

Can somebody help me to fix this. Why does this happens.

chulett · Post by **chulett** » Tue Jul 28, 2009 6:41 pm

Assuming the queries are identical, there are a couple of reasons I can think of - they are sourcing from different instances or perhaps the source is 'dynamic', i.e. records were added before the second one was run.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 28, 2009 7:24 pm

Moderator: please move to server forum

If this is actually a parallel job, then getting the partitioning wrong might be a contributing cause.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jul 29, 2009 2:06 am

Download both results in a sequential file and do a diff.

Check whether there are null values in non-nullable fields.