Home Forums Data Warehousing Strategies and Ideas Effective date updation in Fact records RE: Effective date updation in Fact records

  • April 27, 2016 at 2:31 am

    #1874872

    Output the new facts to a working table. Then use T-SQL to insert the new records and update the old ones.

    Jez