Post reply

Can a conditional split do this?

  • September 8, 2011 at 7:23 pm

    #257138

    I'm trying to deal with 3 different scenarios listed below. I would like to do it using a conditional split (not an SCD). Is it even possible? If so, how?

    Business Key and Checksum:

    IF BK in "left" table but not right THEN New

    IF BK in left and right tables but different checksumsTHEN Modified

    IF Same BK and same checksum THEN Unchanged

  • September 9, 2011 at 5:49 am

    #1379134

    imani_technology (9/8/2011)

    I'm trying to deal with 3 different scenarios listed below. I would like to do it using a conditional split (not an SCD). Is it even possible? If so, how?

    Business Key and Checksum:

    IF BK in "left" table but not right THEN New

    IF BK in left and right tables but different checksumsTHEN Modified

    IF Same BK and same checksum THEN Unchanged

    Yes, just put your three conditions in the order you want them evaluated in the task. See attached image.

    HTH,

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply