DSXchange

Posted: **Tue Nov 01, 2016 12:17 am**

Hi All,

We can do Union all condition with funnel stage, how we can implement the union logic in datastage ?, can some one help.

Posted: **Tue Nov 01, 2016 6:56 am**

Remove duplicates stage afterwards.

Posted: **Wed Nov 02, 2016 12:54 am**

You mean after using funnel stage, add remove duplicate stage ?

Posted: **Wed Nov 02, 2016 6:36 am**

As one solution, yes, since the only difference between a UNION and a UNION ALL is the former removes duplicates.

How to do a Union condition in Datastage