Major objective of this paper is to lay the guidelines, which is an attempt to document the generalized test process that can be followed across BI/DW domain.This paper excludes the automation & performance aspects of ETL Testing.

Most of the organizations already have a mission statement – addressing the stakeholders – although it may not be well-integrated into the day-to-day business.

Some companies can boost performance by just unearthing their old mission statement and linking their values with their Corporate Performance Management (CPM).

He has earlier represented Microsoft and Oracle at International test conferences as a Speaker. Email: [email protected] a Senior Test consultant (Microsoft IT Professional SQL Server BI 2008 Certified) for Microsoft India – Business Intelligence Engineering team, is currently responsible for planning the testing of a large scale BI/DW application on SQL Server 2008 platform and in the past has led teams to test various products end to end.

He draws from his Master in Business Management from IIM (Indian Institute of Management, Calcutta) background to help organizations improve customer satisfaction, manage change, and strengthen process maturity.

He also has specialized in training and consulting on testing, inspections and reviews, and other testing and quality-related topics.

Almost all of their initiatives succeed, and even when something fails, it has only a temporary impact.

When you dont have conformed dimensions to link one data mart to other, then its called a stove pipe model Regards - Praveen" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="1265429" /Stove pipe model (not a model, more of a way of avoiding engineering IM/DW/BI the right way, due usually to ignorance, allegiances, or both). Martyn Richard Jones Data Warehouse Architect" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="1265579" / Simple explanation: Stove pipe model (not a model, more of a way of avoiding engineering IM/DW/BI the right way, due usually to ignorance, allegiances, or both). Martyn Richard Jones Data Warehouse Architect the sub systems, Stove pipe archtitecture of data system enables segregated access to data for various sub systems without having to secure a cross-fu nctional consensus on business rules, business definitions and report/analy tical views. Practically I , too , am lo oking for some case studies to analyse the advantages and/or disadvantages of this approach to comprehend it better.

Conformed dimensions across data marts (a way to justify the logically injustifiable, trying to build a Data Warehouse without actually having a Data Warejouse a.k.a. Conformed dimensions across data marts (a way to justify the logically injustifiable, trying to build a Data Warehouse without actually having a Data Warejouse a.k.a. regards, akshaya bhatia" id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="1266442" / Unlike datawarehousing architecture of consolidating data across the sub systems, Stove pipe archtitecture of data system enables segregated access to data for various sub systems without having to secure a cross-fu nctional consensus on business rules, business definitions and report/analy tical views. Practically I , too , am lo oking for some case studies to analyse the advantages and/or disadvantages of this approach to comprehend it better. You will never ever EVER want to build stove-pipe data marts, one shouldn't even do that to even your worst enemy - okay, there are exceptions, but they must be really really deserving of something unpleasant. You will never ever EVER want to build stove-pipe data marts, one shouldn't even do that to even your worst enemy - okay, there are exceptions, but they must be really really deserving of something unpleasant.

There are many factors contributing to the above stated problem, one of that is definitely the lack of standard test process to test an ETL or any Warehousing application.