Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Leonard Anatomy of an Incremental Load RE: Anatomy of an Incremental Load

  • February 11, 2008 at 2:44 pm

    #777094

    cmcklw (2/11/2008)

    Rick Todd (2/11/2008)

    cmcklw:

    I'm doing my compare based on the Business Key of the table, as opposed to something I'm generating internally (like the Surrogate Keys I'm generating with an IDENTITY column). Is this possible in your situation?

    HTH,

    Rick

    Yes. I think that would work but I wanted to know the best way to deal with a table that does not have a Business Key and the only key is an identity column.

    Thanks,

    -Kevin

    I guess we'll wait for Andy or someone else to weigh in, but I can't see how you can use any of this logic if you don't have a Business Key to make sure you're matching up the right rows.


    Rick Todd