Union eliminate duplicates, union all doesn’t eliminate dups..

Ex:

[code=oracle]

TABLE_1 :

SELECT * FROM DB2.*.Table1
WHERE NUM = '400005898' WITH UR;
---------+---------+---------+---------+---------+---------+---------+-
NUMBER APPLIED_DTSTMP EFF_DT...