DSXchange

Posted: **Fri Nov 21, 2014 7:53 am**

Hi,

I am running a simple source to target data migration job. My log says following,

SOURCE_TABLE,0: Number of rows fetched on the current node: 897.
TARGET_TABLE,1: Number of rows inserted on the current node: 448.
TARGET_TABLE,0: Number of rows inserted on the current node: 449.

But when i look in the table there are only 442 rows inserted.

I am sure my query is not wrong because i am inserting data into a empty table.

What can be the probable reason?

Posted: **Fri Nov 21, 2014 9:45 am**

One guess is that you are truncating or deleting the target table multiple times in parallel? Another guess is your target table may have a different primary key defined than the source table?

Posted: **Fri Nov 21, 2014 3:55 pm**

Do you have a rejects link to capture any rows the were sent but failed to be inserted?

DSXchange

Data missing in table but log says data inserted

Data missing in table but log says data inserted