Table Comparison in SAP BODS

[former_member609239]

There is a source table A and it has 2 columns namely Empid and Empname. Empid is the primary key column.There is a target table B it also has the same structure as source table A, Empid and Empname there is no primary key for the target table. Target table B was loaded with 2 records during 2015, there is a delta record in source table which has occurred now.Target table data LOADED during 2015 is like this:

Empid Empname

1 Amir

1 Shenaya

Source table which has got the delta records(now) is as follows

Empid Empname

1 Carol

When we use table comparison for updating the delta records the output is as follows:

Empid Empname

1 Carol

1 Shenaya

Why is the 1st record alone updated why not the 2nd record?