Skip to Content
0
Aug 01, 2016 at 07:42 PM

Inconsistency in Smart Data Integration:Aggregation Transformation [SPS09]

67 Views

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

Attachments

1.JPG (64.2 kB)