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
Thank you for sharing such great information but I would like to add that AsiaPack offers the Best consolidation warehouse services, as well as superior fulfilment services at reasonable pricing. providing services to fulfil the demands of clients This allows you to simplify logistics and shipping while enhancing delivery efficiency, management, and accessibility.
ReplyDelete