DSXchange

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

Transformer before then sum in the Aggregator.

Or do the summing in the Transformer itself.

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 ?

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

Performance - Faster computation with least resources consumed :D

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