Database Delegation
In large-scale Data Warehouse deployments, performance of reports are critical for users of the system. Designers and Developers several tricks under their belt, among which […]
Data Modeling
Conformed Dimensions
Dimensions correspond to master data and are critical building blocks of any Data Warehousing Environment. Irrespective of the modelling approach adopted such as Star or […]
Degenerative Dimensions
A common problem in BI initiatives that typically mushrooms after systems have been running for quiet some time is “lack of query speed“. Performance optimization […]
MDM – Propagating Data
This is the second critical aspect of any MDM tool. The first critical part can be found here. On one side, MDM enforces data quality […]
How MDM works – Collecting Data
In order to understand other aspects of MDM, refer to Part 1 and Part 2. MDM has two major functions that ensures that data quality […]