DSXchange

We have developed a parallel job to load a tab delimited text file to an oracle table.There are few numeric columns in the text file with null values.

Due to this the file is not getting loaded to the database.The following are the warnings we get,

Seq_Pbip_Line_Utl_Dtl,0: Field "LINE_UTL_IN_PER" has import error and no default value; data: <empty>, at offset: 89

Seq_Pbip_Line_Utl_Dtl,0: Import warning at record 172.

Seq_Pbip_Line_Utl_Dtl,0: Import unsuccessful at record 172.

Could you please help us out in resolving this issue ?

In the format tab of the Oracle Stage and under Field Defaults property and set the Null field value property to the default you want. You have to handle nullable fields.

I tried setting default values for the null fields,but still the same error.

Did you set the same on the source side too. It shows import error. Whats the NullFieldvalue you set on the source side..can you set this to \1 and check what happens...

I tried that too..but still the same error...

It seems likely that you have been insufficiently diligent in accurately setting null field values. You have an empty field at column position 90 (the figure 89 is zero-based numbering) which is the field LINE_UTL_IN_PER; has this field's Null Field Value property been set to ""? Can you see the NULL when you View Data (set skip to 170 and rows to 5 in View Data)?