Difference in SQL Output

vikibemech · Post by **vikibemech** » Mon May 20, 2013 3:43 am

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.

jerome_rajan · Post by **jerome_rajan** » Mon May 20, 2013 3:50 am

Different schemas maybe? Can't think of anything else

vikibemech · Post by **vikibemech** » Mon May 20, 2013 5:42 am

No change in schema. Also checked parameters and no issues seen.

priyadarshikunal · Post by **priyadarshikunal** » Mon May 20, 2013 11:44 am

Or the data in database is changed by someone else in your team?

vikibemech · Post by **vikibemech** » Mon May 20, 2013 12:05 pm

No one change any. Sorry

pnpmarques · Post by **pnpmarques** » Fri May 24, 2013 11:48 am

When you run the select statement in an another application how many records do you get?
Do you have any filters in transformer?
How do you actually see the records loaded into the file, through Monitor or do you open the file?
Try to split the job into pieces to locate the problem.

Regards,
Pedro.