to find minimum of timestamp column

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
s_porkalai
Participant
Posts: 38
Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai

to find minimum of timestamp column

Post by s_porkalai »

hi ,
my requirement is to find the minimum value of timestamp column. when i use aggregrator, it is producing result in double so i am not getting the appropriate results. what stage i should use for this purpose
thanks & Regards
A.S.Porkalai Lakshmi
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Same stage - '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>
s_porkalai
Participant
Posts: 38
Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai

Post by s_porkalai »

thanks george
thanks & Regards
A.S.Porkalai Lakshmi
Post Reply