none
Question about AdventureWorksDW2008R2 sample database

    Pertanyaan

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

    • Dipindahkan oleh Challen Fu 27 Maret 2012 5:36 (From:SQL Server Analysis Services)
    24 Maret 2012 22:36

Jawaban

  • 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

    • Ditandai sebagai Jawaban oleh amx2012 06 April 2012 22:00
    28 Maret 2012 2:53
    Moderator

Semua Balasan

  • Hi amx,

    I move it to SQL Server Samples and Community Projects forum to receive more specific support.


    Challen Fu

    TechNet Community Support

    27 Maret 2012 5:40
  • 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

    • Ditandai sebagai Jawaban oleh amx2012 06 April 2012 22:00
    28 Maret 2012 2:53
    Moderator
  • Hi Jeff,

    What would be the update senario? Should I update the record and set the RevisionNumber to 2 or insert a new record with updated data and RevisionNumber = 2?

    Thank you for help,

    28 Maret 2012 4:19
  • It depends on how you'd like to handle fact table updates. 

    As you are now seeking advice on how to handle fact table updates, I'd suggest that you post your question in one of the SSAS forums http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads


    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

    29 Maret 2012 0:48
    Moderator