Data warehouse Sources

The OLTP systems, transaction systems, live databases, operational systems – whatever they are known as in various fora, these are are all source data for the data warehouse. The source data cannot be normally used for analytic information as they are:

• Not Optimized for Reporting
• Data schema optimized for transactions not queries
• Difficult to share data
• Typically do not maintain historical data

Data warehouse architecture 1