Row count not matching between DS and toad

devnhi · Post by **devnhi** » Wed Oct 06, 2010 8:40 pm

When i run the ds job I am getting 1.8 M . When i run the same sql on Toad its getting 2.4M (Correct count). DataStage not showing error in the logs and its not suppressing any logs. Please help me in the above issue

anbu · Post by **anbu** » Wed Oct 06, 2010 9:13 pm

Check whether you have any constraints in sql or in transformer stages

jagadish9 · Post by **jagadish9** » Wed Oct 06, 2010 9:16 pm

I have validated all the date constraints. I have pasted the same sql in toad and DS and there is no constraints on Transformer. The records were missing in the ODBC stage it self. Source DB is Oracle.

vmcburney · Post by **vmcburney** » Thu Oct 07, 2010 12:05 am

Is it the same database? Is it the same database schema? Are they both running under the same user account? Is it the exact same SQL including use of inner/outer joins? Is DataStage reading 2.4M rows but writing out 1.8M rows due to a constraint?

Sreenivasulu · Post by **Sreenivasulu** » Thu Oct 07, 2010 12:56 am

The logs shows the correct value. But if the job finishes with warnings then it does not show the correct value.

You cannot rely on the count shown in the links since they might be inconsistent even for a job finishing without warnings

Regards
Sreeni

kduke · Post by **kduke** » Thu Oct 07, 2010 10:02 am

You need a reject link on the stage that loads to the database.