locked
Duplicates on SQL server replication RRS feed

  • Question

  • Hi All,

    We are having a bit of a strange problem with SQL Server. I am not SQL Server skilled. I am supporting an Informatica platform where we are connecting to SQL Server replication database and pulling data across. We connect to a view which does a simple select on the base table. We bring the data across. For one particular day, we have seen duplicates come through for the primary key. There are two records coming through which are exact duplicates. Duplicates for every column.

    But after the job completes, if we query the DB, the duplicates are not showing. Is it possible for the replication to do something that would make our job pull across two rows instead of one ? Strange question and Strange scenario ? But, have anyone come across similar issue ?

    We use informatica, which establishes a mixed mode connection from AIX to SQL server DB and issues a single select statement. ~3 M rows are brought across, of there ~10K rows are exact duplicates. The duplicates are showing in our DB, but if we query SQL Server DB after the job completes, there are no duplicates.

    Please advice.

    Wednesday, August 27, 2014 2:32 AM

Answers

All replies