Data Mart Consolidation

Data Mart consolidation at many instances is an immediate tool for saving cost in software and hardware infrastructure, but when executed effectively consolidation projects can also help in eliminating redundant and dormant process ensuring a new optimized system. There are still many questions in terms of What is consolidation? Why should I do it? When should I think of consolidation? And How do I go about doing consolidation? This article answers these questions. Also details in terms what needs to be looked at the metadata level for the consolidation process?