Case statement in Aggregator stage

vishu19aug · Post by **vishu19aug** » Mon Jun 25, 2012 1:02 pm

Hi,

I need to do the following Oracle functionality in Datastage -
sum(case when field1 = 'X' then 1 else 0) countx,
sum(case when field1 = 'Y' then 1 else 0) county

Is it possible to do this in aggregator stage or i need to put this logic in transformer stage before the aggregator.

Thanks,
Vishal

chulett · Post by **chulett** » Mon Jun 25, 2012 1:05 pm

Transformer before then sum in the Aggregator.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 25, 2012 5:05 pm

Or do the summing in the Transformer itself.

zulfi123786 · Post by **zulfi123786** » Tue Jun 26, 2012 1:24 am

ray.wurlod wrote:Or do the summing in the Transformer itself.

summations in transformer Vs summations in aggregator

Could you please highlight the performance trade off amongst the two choices ?

ray.wurlod · Post by **ray.wurlod** » Tue Jun 26, 2012 4:11 am

No idea. Define what you understand by "performance" in an ETL context.

zulfi123786 · Post by **zulfi123786** » Tue Jun 26, 2012 7:12 am

Performance - Faster computation with least resources consumed :D

ray.wurlod · Post by **ray.wurlod** » Tue Jun 26, 2012 5:05 pm

In that case, try both while monitoring or gathering performance statistics.