Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?
Want to build a kind of a scientific fact search and analytical engine for a lot of different types of measurements hosted in a lot of source tables and columns. A star join schema is built and data is copied (ETL) from the sources as usual – but all source column values are stored into [...]

Answer Question   |  December 22, 2009  12:07 PM
Data Warehouse Planning, Data warehousing, SQL

Build a Data warehouse end to end
Im asked to build a datawarehouse from end to end. I have already worked on datawarehousing projects. I need to prepare a proposal document. How do i prepare a proposal document that explains End-to-end development. Can I get a sample document? Thanks.

Answer Question   |  January 9, 2012  12:39 PM
Data Warehouse Planning, Data warehouses, Data warehousing