Do I understand well that it is not possible to calculate the max/min of a character field. Since datastage converts the output automatically to a double, the calculation becomes always 0 in case of a string input.
I read here something about preserve type, but that option is not available.
Regards
aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
'Aggregator' can be used with option 'Preserve Type' as true. If you don't have this option in your 'Aggregator' stage under 'Aggregations -> Column for calculation -> Available properties to add -> 'Preserve Type' then you might have to contact provider for this fix.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>