Q1 :- Four-Step Dimensional Design Process
Objective: design of a dimensional database by considering four steps in a particular order:
1. Select the business process to model
2. Declare the grain of the business process
3. Choose the dimensions that apply to each fact table row.
4. Identify the numeric facts that will populate each fact table row
https://dwbi1.wordpress.com/2010/03/05/transaction-dimension/
http://byobi.com/blog/2013/09/dimensional-modeling-junk-vs-degenerate/
http://dwhlaureate.blogspot.in/2012/08/junk-dimension.html
https://bintelligencegroup.wordpress.com/2012/06/05/different-types-of-dimensions-and-facts-in-data-warehouse/
http://www.disoln.org/2013/12/Design-Approach-to-Handle-Late-Arriving-Dimensions-and-Late-Arriving-Facts.html
5. MDM :- Consolidation,Harmonization,Centralization,Distribution
