I need to load files in vertica using copy but i do not want duplicate entries. As unique constraint will not be helpful as it will load data and then i may have to delete duplicate entries from ananlyse_constraints().Other is using insert with bit of logic to check wether entry exist in table. I need some better logic which will restrict duplicate entries.With examples will be very helpful.
Thanks
Kundan
