0 Replies Latest reply: May 1, 2012 11:34 AM by ss396s RSS

    updating values in a bridge table after insert

    ss396s
      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.

      Suggestions..