Union

pradeep_nov18 · Post by **pradeep_nov18** » Tue Aug 19, 2008 12:13 am

Hi Experts,

How to perform Union operation for two tables.which stage shuold i use for this in datastage

Thanks in Advance.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Tue Aug 19, 2008 12:14 am

use funnel stage

ray.wurlod · Post by **ray.wurlod** » Tue Aug 19, 2008 12:19 am

Funnel stage is really UNION ALL. If what you want is UNION use a Funnel stage followed by a Remove Duplicates stage (which implies a sort in there somewhere).

pradeep_nov18 · Post by **pradeep_nov18** » Tue Aug 19, 2008 12:23 am

ray.wurlod wrote:Funnel stage is really UNION ALL. If what you want is UNION use a Funnel stage followed by a Remove Duplicates stage (which implies a sort in there somewhere). ...

Ok Thanks ray

ray.wurlod · Post by **ray.wurlod** » Tue Aug 19, 2008 12:47 am

Best, of course, if the two tables are in the same database, is to perform the UNION in the SQL you use to extract rows from that database.