Issue in reading null values for float data types in file

[mallikharjuna]

Hi All,

I am facing Issue in reading null values for float data types in sequential file.

my requirement is not to change data type and not to use any default value.

if we change datatype as varchar then it is possible to convert to float data type and load null values in sap BW system?

Thanks in advance...

[chulett]

Well... technically there are no data types in a flat file other than string / varchar so you could certainly read it like that and then do an explicit conversion to whatever it needs to be. At least that way you have full control over it rather than letting the stage do an implicit conversion during the read / import operation.