How merge stage works
Moderators: chulett, rschirm, roy
How merge stage works
I was facing one preblem. the merge stage process two files. all filds are direct writen to a new output file. something I do not understand is some field in source is null become others field's value in target file. if I replace the null with 'NULL' in source, 'NULL' will be writen in target file correctly. IT seems that merge stage can not hanlde null string properly. Does any one know how merge stage work?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Re: How merge stage works
You can know that by going through DataStage Online Manaual.changming wrote: Does any one know how merge stage work?
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
Re: How merge stage works
Try setting the 'Nullable' type for those fields to 'Yes' in the 'Columns' tab of your Merge Stage. That should fix the problem.changming wrote:I was facing one preblem. the merge stage process two files. all filds are direct writen to a new output file. something I do not understand is some field in source is null become others field's value in target file. if I replace the null with 'NULL' in source, 'NULL' will be writen in target file correctly. IT seems that merge stage can not hanlde null string properly. Does any one know how merge stage work?