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,

    • Přesunutý Challen Fu 27. března 2012 5:36 (From:SQL Server Analysis Services)
    24. března 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

    • Označen jako odpověď amx2012 6. dubna 2012 22:00
    28. března 2012 2:53

Všechny reakce