Null handling Decilmal and varchar

[Deepakinstyle]

Hi,

My requirement is to generate .txt files from a table. i am using a oracle, transformer and Seq file stage.

we have few columns which are decimal and varchar and are nullable. while writing many of the records are dropped for handling the null values.
please let me know how handle nulls??

Thanks in advance,
Deepak

[betterthanever]

convert the decimals to varchar before writing to the file
and mention some null field value in the format page of the sequentail file so that the null fields will be filled with the mentioned value...

[Deepakinstyle]

Hi,

Thanks for the reply.

In the o/p seq file i want null values for that column.

if i specify NullFileldvalue = '' will it work???

thanks,
Deepak

[betterthanever]

yes

[Deepakinstyle]

thanks. it worked