Before Insert Trigger

[sagisunbluez]

Hi,

I am trying to trap duplicate records before inserting in the stagging table. But not able to do so. The data is transfered from MS-SQL Server in DTS format in oracle stagging table. But duplicate data is also imported.

Can any one help with the before insert table. i am usg DB 8.1.7

Regards

sagi

[admin]

Create a primary key on the table and while inserting handle duplication in the exception. thanks