DSXchange

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.

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.

Moderator: please move to server forum

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

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

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