DSXchange

Hi,
can you please tell me how to handle nullable field in seq file.
when i running a job in parallel.i am getting the following warning.

Null field handling without nullable properties

Thanks for u r help in advance

You will need to find out what the biz rule for defaulting NULLs is.
THen In the Transformer stage based on the null default write a IF THEN ELSE clause as -
If NULL THEN <default value> ELSE column.

jagadish9 wrote:Hi,
can you please tell me how to handle nullable field in seq file.
when i running a job in parallel.i am getting the following warning.

Null field handling without nullable properties

Thanks for u r help in advance

hI,

You select the Nullable is YES and your not handleng the NUlls in Format tab.

Pls select the Field default then Null fileld Value="\000"

Regards,
Ravi Babu.B

Go to the Columns grid and edit the extended metadata for the Nullable column. Set its Null Field Value property (in the Nullable folder). If the sequential file is fixed width then the number of characters in the Null Field Value property must exactly match the number of characters in the field itself.