Data missing in table but log says data inserted

sarathchandrakt · Post by **sarathchandrakt** » 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?

qt_ky · Post by **qt_ky** » 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?

ray.wurlod · Post by **ray.wurlod** » 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?