DQS Matching - writing Matched records to existing table with data? RRS feed

  • Question

  • I matched output from one DQS Matching task to dbo.MatchedRecords.

    At a later subsequent step in SSIS I also write output from another DS Matching task to the same table.

    I was concerned that there would be a clash when the second DQS Matching task tried to write to the my table dbo.MatchedRecords with the same RecordId?

    I had no issue and the second DQS Matching task uses generates different RecordId's.

    How does DQS Matching do this - does DQS Matching check the Record Id's in the existing table?


    Sunday, December 7, 2014 5:15 PM

All replies

  • Inspect the RecordID values in the DataViewer.

    I do not know what is your setup. Images, examples would be good.

    I suspect you just need a test that targets the duplication




    Monday, December 8, 2014 2:23 PM