Hi
I want to do a union of two tables in DataStage, without using User-defined SQL statement.
What is the alternative?
Thnaks
Union
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Good point. I had forgotten that. I also forgot that SortFunnel was part of Torrent Orchestrate, not DataStage. If you want to sort the output of the funnel, choose the 'Sort Funnel' funnel type option within the Funnel Stage. Then your data is ready to be dedup-ed with the RemoveDups stage.ray.wurlod wrote:The Funnel stage is really UNION ALL. If you want just UNION, follow the Funnel stage with a Remove Duplicates stage.
brad.