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
Null handling Decilmal and varchar
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: Null handling Decilmal and varchar
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...
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...
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Re: Null handling Decilmal and varchar
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
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
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Re: Null handling Decilmal and varchar
thanks. it worked