Regarding Aggregator Stage

[Saama]

Hi Gurus,

My design is odbc------> aggregator-------->odbc
--------------->sequential file.

Sorry my design is not clear.

Actually i am connecting aggregator stage to ODBC and Sequential file.

i want to calculate the sum and store in the ODBC, while the remaining columns should go to sequential file.

my source stage has columns like empno,ename,sal,dept
target odbc stage should store sum(sal), while target sequential file should have all the remaining columns.
Is it possible, please help me.

cheers;
vijay

[DSguru2B]

Sure. Use a transformer to split your columns. Pass the gouping keys and sum to odbc and the remaining to the sequential file stage.

[Saama]

Hi Gurus,
Thanks very much.Iam marking this topic as resolved.

cheers;
saama