| Dependent Data Warehouse | Independent Data Warehouse |
| A dependent data warehouse stored the data in a central data warehouse. | Independent data warehouse standalone systems built by drawing data directly from operational or external sources of data, or both. |
| Dependent data ware house are build ODS. | Independent data warehouse will not depend on ODS. |
| The ETL process for dependent data marts is mostly a process of identifying the right subset of data relevant to the chosen data mart subject and moving a copy of it, perhaps in a summarized form. | The number of sources is likely to be fewer and the amount of data associated with the data mart is less than the warehouse, given your focus on a single subject in an independent data warehouse. |
| Dependent data marts are usually built to achieve improved performance and availability, better control, and lower telecommunication costs resulting from local access of data relevant to a specific department. | The creation of independent data marts is often driven by the need to have a solution within a shorter time. |
