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.