max of decimal(38) in aggregator stage gives junk values

[ravi7487]

Hi,

My Dimension ID from teradata table is varchar38.
I have to find the max(dimension ID) in aggregator stage

I am converting varchar38 to decimal38 in transformer, and doing max(dimensionID) in aggregator stage.

after the agg stage, My output is coming as some junk integer.

I tried stringtofloat... bigint, double.. all are giving junk numbers.

could you please let me know how to solve this issue.

[chulett]

Perhaps this 'junk' is in your source data?