DSXchange

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

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

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.
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.

Take the error message after "COMM" and do an exact search for it here.

Set the null field value in sequential file stage ...

Thanks guys

The workaround works