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,

Answer 1

Hi amx,

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

---

Challen Fu

TechNet Community Support

Answer 2

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

Answer 3

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,

Answer 4

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