0 Replies Latest reply on May 1, 2012 4:34 PM by ss396s

    updating values in a bridge table after insert

      any suggestions on this:

      I am loading a fact table, dimension table and a bridge table. The bridge table will need to have a percentage which is calculated by dividing the records per order by 100% to obtain the number. I was going to do a view on the source, but I am likely going to use streams and CDC, so it makes that not practical.