Union

arindami · Post by **arindami** » Wed Sep 14, 2005 10:25 am

Hi

I want to do a union of two tables in DataStage, without using User-defined SQL statement.
What is the alternative?

Thnaks

bcarlson · Post by **bcarlson** » Wed Sep 14, 2005 1:18 pm

The Funnel Stage - takes 2 or more inputs of identical layouts and outputs one stream of data. There is also a SortFunnel that works the same way but sorts the data as it passes through.

Brad.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 14, 2005 3:31 pm

The Funnel stage is really UNION ALL. If you want just UNION, follow the Funnel stage with a Remove Duplicates stage.

bcarlson · Post by **bcarlson** » Wed Sep 14, 2005 4:48 pm

ray.wurlod wrote:The Funnel stage is really UNION ALL. If you want just UNION, follow the Funnel stage with a Remove Duplicates stage.

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.

brad.