Database Query vs. DataStage Stages

kksr · Post by **kksr** » Tue Dec 05, 2006 2:42 am

Hi All,

Source Database : Oracle.
I need to calculate some max value for the one of my source column. For this I need to write SELECT query in oracle stage is better or I can go for Aggregate stage and which will give you the best performance in PX??

kumar_s · Post by **kumar_s** » Tue Dec 05, 2006 2:49 am

If it is simple MAX function, database option will give you quick response. That again depends on how busy you database is.

kumar_s · Post by **kumar_s** » Tue Dec 05, 2006 2:50 am

Hi,
You can delete the other duplicate post created for the same topic.