max of decimal(38) in aggregator stage gives junk values
Posted: Mon Aug 15, 2011 8:50 am
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.
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.