Hi,
I have migrated one server job which contain merge stage from 7.5 to 8.1. Now when i am trying to run the job ,i am getting more number of rows in 8.1.When i checked the target file , some blank rows are present at the end of the file which are not in 7.5.
The size of the two input files in merge stage is same in both 7.5 and 8.1.
Please help me to solve this .
Thanks in Advance
Merge Stage -Differnence in row count
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Wed May 19, 2010 12:15 am
- Location: Pune
Merge Stage -Differnence in row count
" Dream like you will live forever, live like you will die today."
-
- Participant
- Posts: 33
- Joined: Wed May 19, 2010 12:15 am
- Location: Pune
I checked with diff command .Thers is no difference in the datas .
One more thing I noticed is,If i am using left outer join in 8.1 i am getting the same number of rows as in 7.5.But if we use complete set option differnce in rows will come.
Thanks in advance
One more thing I noticed is,If i am using left outer join in 8.1 i am getting the same number of rows as in 7.5.But if we use complete set option differnce in rows will come.
Thanks in advance
" Dream like you will live forever, live like you will die today."
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
We had similar kinda problem when migrating from 7.5.2 to 8.1
But a little different issue. 7.5 gave more rows than 8.1
As per IBM's suggestion, we set the NLS of each column in the merge stage to be UTF-8 and it worked fine! :D
But I really dont understand about it yet, because our NLS project defult is UTF-8![Mad :x](./images/smilies/icon_mad.gif)
But a little different issue. 7.5 gave more rows than 8.1
As per IBM's suggestion, we set the NLS of each column in the merge stage to be UTF-8 and it worked fine! :D
But I really dont understand about it yet, because our NLS project defult is UTF-8
![Mad :x](./images/smilies/icon_mad.gif)
Arun