Hi all,
Funnel stage does union operation corresponding to the input and the output link or it does union all operation?
I want to remove duplicates as well, so i have doubt whether i have to use remove duplicates stage or not after that.
Thanks in advance.
funnel stage
Moderators: chulett, rschirm, roy
Re: funnel stage
Yes.dsscholar wrote: I want to remove duplicates as well, so i have doubt whether i have to use remove duplicates stage or not after that.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Funnel puts all rows from all inputs onto its single output. That's a UNION ALL. There is no capacity within the Funnel stage to remove duplicates. Remember, one task, one stage type.
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.