Question about AdventureWorksDW2008R2 sample database


  • Hi,

    I found that all of the facts tables in the AdventureWorksDW2008R2 include a RevisionNumber column which always includes “1”.

    What is the usage of RevisionNumber colums?

    Thank you,

    • Spostato Challen Fu martedì 27 marzo 2012 05:36 (From:SQL Server Analysis Services)
    sabato 24 marzo 2012 22:36


  • Data in fact tables can change over time so one implementation for tracking changes is to implement a Revision/Version number.  The values are all 1 because no changes have been made to the data in the fact tables.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    • Contrassegnato come risposta amx2012 venerdì 6 aprile 2012 22:00
    mercoledì 28 marzo 2012 02:53

Tutte le risposte