DSXchange

Is RCP( Run time Column propagation) works with Aggregator ?
I want all the columns of my input to be present in output too.

I know we can do the same by using join. I do not want to use it.
Any other way ?

I tried with RCP but no luck...

any help will be great

if RCP is used for Aggregator stage only those column will go to output , which are there in the mapping tab of aggregator on the left side(left side on the mapping tab).I have tried it once with sequential file as input to aggregator and sequential file as output to aggregator.

Is this interview question???

i hope this will help.

Cheers,
ZDC

Think about it in SQL terms. What are the rules in SQL? Every column named in the SELECT clause, if there is a GROUP BY clause, must either be mentioned in the GROUP BY clause or have a set function applied to it.

A column propagated via RCP would meet neither of these conditions.

Therefore it would be illegal if it were possible.

Therefore it is not possible.

QED

Thanx for the replying... it helps...
BTW its not an interview Question... it is a practical problem I faced in my project...

can you think any other way we can acheive this ?

Do an exact search on "aggregator". This has been answered before. You would have to use Sort, Copy and Join stages along with Aggregator stage to get all the columns and the calculated field.

It's usually called a "fork join" design.