0 - 1 of 1 tags for SQL UNION COUNTS

Hi All,
I want to remove the complete row level duplicates from multiple source while inserting to the target table.
I cant do UNION or I can create a SET target table.
Which approach will have better performance ?
Thanks,
Ambuj