Aggregator Convert from Double to VARCHAR

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srireddypunuru
Premium Member
Premium Member
Posts: 40
Joined: Thu Jul 10, 2008 12:45 pm

Aggregator Convert from Double to VARCHAR

Post by srireddypunuru »

I am using Aggregator to get the Max Value once i do that i get the output in the double datatype as expected. The output what i get is 7604 but expected is 007604.I will be using this data for join in the next Join stage but my join is failing as output isnt as expected as 007604.

2 Questions.

1) How do i convert Double or Float to Varchar as my join key filed in further stages is VARCHAR.
20 I tried using DfloattoStringNoexp but it was giving exponential values.

Any suggestions will help !

Thanks
Sri.
Srikanth Reddy
Integration Consultant
Post Reply