My presentation at SQLBits 5 last Saturday is here: Building Cubes From Operational Systems.
SQL Scripts for the DDL and DSV are here: SQLScripts.zip, and the BIDS project files are here: Broker5.zip.
Any problem downloading please let me know.
Advertisements
[…] 2. CustomerKey. In the stock broker data mart (see my SQLBits presentation here for a background), in the account balance fact table we have AccountKey, OrderDateKey, […]
Pingback by Putting Higher Grain Attributes into a Separate Dimension « Data Warehousing and Business Intelligence — 5 March 2011 @ 6:23 pm |
[…] is an order table in a stock brokerage company (click here for a background). It has these 3 columns: Order date time, cancellation datetime, settlement date. […]
Pingback by Datetime Columns in a Fact Table « Data Warehousing and Business Intelligence — 8 March 2011 @ 10:03 pm |