Divident by zero
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Dividend by zero
By seeing the log in Director, I have taken the transformer count (4th trans in log). Error msg i have mentioned above. 5 columns coming as input to transformer (as mentioned above). let me know if you have any questions.
Vignesh Kumar N
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Dividend by zero
DataStage Job 1130 Phantom 10132
Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.
Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.
Vignesh Kumar N
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Dividend by zero
Have you checked the file Names in the hashed file ? ie.. Input and output.. check that once... I assume that they are different in your case.vikibemech wrote:thanks for the info. I walked through the trans4 stage and there is no arithmatic division in any of the column. My design is like this Seq file-> Agg -> Hash file ->transformer.
Hash file input is 10K records but output is only 33 records(which is the input for Transformer). I am not clear where the other records are? Please advice if any.
Thx
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Divident by zero
Thanks for the info provided till now. Issue has been resolved now.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai