Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Leonard » Updating Rows in Incremental Loads – Level 4...

11 posts, Page 2 of 2

««1 2

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services

Rate Topic

Display Mode

Topic Options

Author

Message

dwilliscp

Posted Tuesday, February 26, 2013 7:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:52 AM
Points: 187, Visits: 332

Andy,

I have a question about the operation and flow of records. Let's make the following change to your data.. Let's assume that the data coming in was using a super key (FirstName, LastName, Email). Then we write the data using only the PK E-Mail, but we grab all the records.

(Lets asume we had the following data already there.. Tim, Jones, tj@aol.com. : Now the data coming in.. (Tim, Jones, Timj@aol.com), (Tim, Jones, Jonest@aol.dom), (Tim, Jones, tj@aol.com)

I think the operation would be.. All records would go to the matching and then tj@aol.com would be dropped, since it matches. The others would update the existing record, so only the last write would exist in the database.

My test seems to prove this... just want to make sure my logic is correct.

Post #1424082

« Prev Topic | Next Topic »

11 posts, Page 2 of 2

««1 2

Permissions