understanding the load_Transform_salescreditcard script

• craig 84462

  Say Hey Kid

  Points: 699

  More actions

  March 30, 2010 at 3:13 am

  #386602

  Hi there,

  I am trying to understand what the update does in this load script. In the above zip file I have created a staging table, loaded the sales credit data into it using an SSIS from the Adventure works database (a sample microsoft sql database). The way I understand is that the load script inserts new records that are NOT in the transform table but ARE in the staging table (ie:hence a right join where t.creditcard is null). However I don't really understand what the update function above is doing. Is it closing off the record by setting dateto=today's date??? but why is there a left join hence. I also can't see anywhere in the final table where the 'update' is working.

  thanks Craig