How to do a Union condition in Datastage

[deesh]

Hi All,

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

[chulett]

Remove duplicates stage afterwards.

[deesh]

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

[chulett]

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