Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help Needed for DataWarehousing Project
Bit late on this. Building on some of the other responses I would suggest the following: Firstly build an OLTP data warehouse schema. So a fully normalised schema for instance with Customer joining to customer address table Customer joining to customer_group table Customer joining to...- Chorlton
- Post #4
- Forum: Data Warehousing/Big Data
-
Dimension hierarchies joining to fact
Currently the DW has standard dimensions, for customer and product these are Type 1 SCD. Mini dimensions have been created for changing hierarchy data on these dimensions (Type 2 SCD). E.g. For customer the mini dimension is: Cust_bus_hier_sk, cust_sk, <Customer Acc No, Cust Group, Business...- Chorlton
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
