Inconsistency in Smart Data Integration:Aggregation Transformation [SPS09]

[former_member182226]

Hi,

Getting error on SDI flowgraph, while doing aggregation on measure of type fixed decimal (13, 2).

Reason: I am applying aggregation type 'SUM' on DOC_CURR_AMT which has data type DECIMAL (13, 2),

but  in OUTPUT_11 anchor of aggregation node, field's data type got changed as DECIMAL( 18 ,2) and it is not editable.

Is there any workaround to remove inconsistency or edit data type in OUTPUT anchor ?

P.S. I can not change the data type in source table.

Thanks and Regards,

Avinash

[former_member183326]

Maybe try posting here: