i am trying to remove duplicates using remove duplicate stage on the emp table using scott user
but getting an error like this ... please provide me a work around for it
Sequential_File_1,0: Field "COMM" is null but no null export handling is defined
Error in running parallel jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Re: Error in running parallel jobs
I guess you are trying to remove the duplicates and then writing it into a sequential file, the sequential file doesnot have any Null concept hence you need to specify a value which then will represent NULLs within the file.luckychn wrote:i am trying to remove duplicates using remove duplicate stage on the emp table using scott user
but getting an error like this ... please provide me a work around for it
Sequential_File_1,0: Field "COMM" is null but no null export handling is defined
Go to the Format tab of the seq file stage and then click on the Field defaults Option, you will find "Null Field Value" option at the lower right corner just click on that and then type in a value wich will be written instead of NULLs. Use the same value as the Null field value while reading the file back so that the seq file stage will import then as NULLs.