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.
max of decimal(38) in aggregator stage gives junk values
Moderators: chulett, rschirm, roy