DW Design RRS feed

  • Question

  • I am looking to build a dw from 2 operational stores.   Both are accounting sources.  One  is sql server incremental transaction log which is applied to local read only db.  The other is foxpro dbf file read via odbc.  We are not really capturing delta's.  

    Also, the data warehouse needs to be retroactively update.  For example, somebody paid a bill for transaction which took place 3 years ago.   Hence, historical summary needs to be updated.

    If any anyone knows of a sample dw db or design documentation, I would appreciate it if you could point me there.

    Monday, October 30, 2017 10:41 PM

All replies

  • Unless this is a learning exercise, I would encourage you to get a data warehouse developer to help you.

    Probably not what you wanted to hear, I'm afraid,


    Friday, November 3, 2017 4:01 AM
  • The AdventureWorks Data Warehouse is a decent one. Also, there is a Contoso example and WorldWideImporters, all can be searched for in Bing or Google.

    Thomas LeBlanc twitter ( @TheSmilingDBA )

    Thursday, December 7, 2017 8:07 PM