none
Question about AdventureWorksDW2008R2 sample database

    Question

  • 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,

    • Déplacé Challen Fu mardi 27 mars 2012 05:36 (From:SQL Server Analysis Services)
    samedi 24 mars 2012 22:36

Réponses

  • 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

    • Marqué comme réponse amx2012 vendredi 6 avril 2012 22:00
    mercredi 28 mars 2012 02:53
    Modérateur

Toutes les réponses