How to join two aggregator

kumar_s · Post by **kumar_s** » Thu Jun 30, 2005 6:06 am

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

bchau · Post by **bchau** » Thu Jun 30, 2005 6:54 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 30, 2005 10:19 am

Try using join stage.

bchau · Post by **bchau** » Thu Jun 30, 2005 6:03 pm

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

ashwin2912 · Post by **ashwin2912** » Thu Jun 30, 2005 11:04 pm

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:

Code: Select all

agg1
	>funnel	>agg3
agg2

kumar_s · Post by **kumar_s** » Thu Jun 30, 2005 11:07 pm

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