Row count not matching between DS and toad
Moderators: chulett, rschirm, roy
Row count not matching between DS and toad
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
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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?
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am