Tuesday, 26 January 2016

FME - Oracle Spatial to SDF

I just discovered an issue when converting Oracle Spatial data to SDF with FME. 

FME translates Oracle's NUMBER(1,0) to DECIMAL(1,0). In Oracle the column contains the following values: 0, 1, <null>. FME translates  value "1" as "-1e+031". One needs to change the data type in SDF file from DECIMAL to INT to avoid this issue.

FME 2014 SP4, 64bit

SDF file - column data type 

...value '1'' translated to -1e+031.

No comments:

Post a Comment