In a number of cases, information within the data warehouse may be subject to privacy laws, which restrict access to data. The extreme case of this is where there must be a complete Chinese wall between different segments of the data warehouse. This situation occurs in the financial sector, where legislative controls may restrict access [...]

Data marts are required in order to support any user access tools that require internal data structures. Data within those structures is outside the control of the data warehouse, but they need to be populated and updated on a regular basis. Some of these tools are often populated directly from source systems, on the basis [...]

Within this step, we must determine whether the business is structured in such a way as to benefit from functionally splitting the data. Look for departmental splits, and then determine whether the way in which the departments use information tends to be in isolation from the rest of the organization. For example, in a retail [...]