Difference in SQL Output
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Difference in SQL Output
There is a difference in SQL output between first 2 runs. First time it says as 30 records as output but when job ran again it throws 4 rows as output. Job design is odbc stage - > Transformer - > Seq File. couple of joins in the SQL. I am getting same results which I get in 2nd run if I run 10 times in a day. Not sure why I am getting wrong results in 1st run. Any help will be helpful.
Vignesh Kumar N
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Different schemas maybe? Can't think of anything else
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Difference in SQL Output
No change in schema. Also checked parameters and no issues seen.
Vignesh Kumar N
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
-
- Participant
- Posts: 35
- Joined: Wed Jun 15, 2005 9:27 am