DSXchange

Im using netezza connector. I try to sum a numeric NUMERIC column using below select statement. However, I always get "did not have a compatible data type. These columns will be dropped from the output link schema" message.

select Sum(col) as ssum from table


May I know what DS datatype I should use? I had tried all of them (may be I missed out).

Thanks in advance

A Numeric data type with sufficiently large precision should be adequate.

Try dfloat (Double), since this is the largest possible numeric data type, and all numeric data types can be implicitly converted to it. Also try reducing the severity of metadata mismatch reports in any Connector stage that you are using.

Beside using Double for the "sum" column, below is the others changes that i did.

At "Netezza Connector" stage, I had change "Type mismatch action" to Keep.

ray.wurlod, billions thanks