You can try either of three different ways to achieve this-
Use of unique key.
Use of incremental strategy: merge instead of append
Use distinct in select query