DSXchange

Hi,
I have 2 aggregator coming, each has a summed up column. i just need to add these two col value after finding abs.
eg: abs(DSLinkn.col)+abs(DSLinkn.col)
Can any one suggest me, what stage can be used to accomplish this.(without using much of resource like intermediate file stage....).
Since most of stage cant hadle 2 inputs.
Thanks in advance
-kumar

From my limited experience with EE, I think you have to use an intermediate stage. Using a lookup stage would be the faster as it loads the information in memory. Use the lookupstage to merge the two outputs from the aggregators so you have a record with 2 columns. Then fire the output of your lookup stage into a transformer where you can sum the two columns.

Try using join stage.

Isn't a lookup stage faster? Or is the difference negligible because it is only 1 record?

What exactly are you aggregating on...if its on a same key value...then you can do it in 1 aggregator itself....then you can directly use a transformer stage for adding the 2 cols.

or if you are having both o/ps from aggregators of same format then use:

Thanks to all,
Thanks ashwin, i used joiner and Transformer instead of funnel and agg3.