The omnient.ini file [Director] section controls whether the Connect CDC Director assumes a NUMBER, no p,s, is defined internally as a FLOAT or an INTEGER:
OracleNUMBERWithoutPrecisionOrScaleIsINTEGER=<1 or 0>-
If this is set to 1, NUMBER is NUMBER(22).
-
if this is set to 0, NUMBER is FLOAT.
The table must be refreshed in order for this NUMBER interpretation to be in effect.