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
Is RCP works with Aggregator ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Is RCP works with Aggregator ?
Thanks
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
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
Is this interview question???
i hope this will help.
Cheers,
ZDC
Zero Degree Consulting
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: