Is An Historical Database Always a Data Warehouse?

Data Warehouse Questions

This year, were planning on creating a data warehouse and implementing an OLAP solution. From what Ive read on this site and others, I will be better off if the data warehouse is designed with a dimensional model. I have a few questions about the

Can Data Warehouse be used as source for operational system

What are the pros and cons of using Data Warehouse (DWH) as source for an operational system? Background:- I work for a company who have now opted to use DWH to populate some of the small operational system's data base, The data in the DWH is

Architecture questions : implement historical data view without SCD?

Hello ! I need some fresh points of view of an architecture Ive just encountered. This solution was designed by a consulting firm specialized in the HR IT field. The DWH in this case is supposed to handle 100000 employees for an organization of

Data Warehouse spread across 4 separate databases

Hello, I started with a new BI team. Our data warehouse was developed by consultants. I find the design very strange, but they insist that it uses BI best practices. I can't find any best practices supporting this set-up. Can anyone help me

Adding new fields to a live system

So, the DW DB is loaded with data of various SCD types. The data is in live use. New requirements arise that require new SCD 2 fields to be added. Backups exist of the source systems. Are there any design tips, experiences that anyone can share on

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Request of information: Italian softwarehouse for federated Data Warehouse

Hello, I work for an Italian financial Company that needs to reorganize the current reporting system (mainly based on Business Objects), which is made of many Data Warehouses and Datamarts in Oracle and SAP/BI. I'm interested in a federated solution

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Data Mining

I'm requesting that folks pitch in and give me their results from bosses. What I'm hoping to accomplish is first of all a verification of preexisting drop rates already determined for the facebook version. Second I'd like to build a proper gear/unit/fp

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise