Consolidating datamarts

The related term spreadmart is a derogatory label describing the situation that occurs when one or more business analysts develop a system of linked spreadsheets to perform a business analysis, then grow it to a size and degree of complexity that makes it nearly impossible to maintain.According to the Inmon school of data warehousing, a dependent data mart is a logical subset (view) or a physical subset (extract) of a larger data warehouse, isolated for one of the following reasons: According to the Inmon school of data warehousing, tradeoffs inherent with data marts include limited scalability, duplication of data, data inconsistency with other silos of information, and inability to leverage enterprise sources of data.I have played many roles, but the perspective I come from is benefit to the end client.I hope the entries can be of some modest benefit to that goal.His team's implementations from both IT and consultant positions have won Best Practices awards.He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA.Whereas data warehouses have an enterprise-wide depth, the information in data marts pertains to a single department.In some deployments, each department or business unit is considered the owner of its data mart including all the hardware, software and data.

For me, each of these fact tables represents a data mart.

I will periodically be sharing my thoughts and observations on information management here in the blog.

I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals.

As the concept of decisional systems, and data warehouses and data marts evolved, two major points of view came into existence. Now, Bill Inmon is an advocate of the Data warehouse.

There are some that argue the best approach is to start with data marts, department by department, then merge them together to form a data warehouse- this is more in line with Kimballs approach.

Leave a Reply