Union Equivalent in Clover ETL Designer

Hi,

I’m trying to union two sets of data coming from two different sources. Is there a way to union the data as opposed to join them?

Thanks,

Hi,

Of course there is, you can use SimpleGather component. For more details, see http://doc.cloveretl.com/documentation/ … ather.html

If you want to preserve even the DISTINCT function of UNION, you can use Dedup component after the SimpleGather.

Regards,

I used the Transformer Component called Merge. It essentially just stacks the two query result sets on top of one another.