how to insert unique records
Posted: Thu Sep 09, 2010 7:39 am
Hi
my reqiurement is to insert the records which are not in the Target(having Cluster Primary Key on Target table).i had 3 jobs and Target is same table,the first job will insert the distinct records(the job finished successful)while the Second job is aborted due to PK violation.
so i need to take the target table in to LOOKUP,but how the logic should be implemented that only the records which are not available in the target should be INSERTED
can u suggest some logic.
Thanks in advance
my reqiurement is to insert the records which are not in the Target(having Cluster Primary Key on Target table).i had 3 jobs and Target is same table,the first job will insert the distinct records(the job finished successful)while the Second job is aborted due to PK violation.
so i need to take the target table in to LOOKUP,but how the logic should be implemented that only the records which are not available in the target should be INSERTED
can u suggest some logic.
Thanks in advance