Data Warehouse Sources › Data Warehouse Sources

Data Warehouse Sources

In the data warehouse environment, it is important to track the source of data. You may have a data warehouse that combines information from several online transaction processing (OLTP) systems, as well as archive data, into a single decision support system. Your data may also come from relational and non-relational sources. To support regular updates and data quality checks, you need to know the source for each column in your data warehouse.

For example, in your dimensional model, the information about stores could come from the corporate production database, while the information about customers could come from both the production system and a data archive. When the administrator updates the data, they need to know the source of the data and its structure (datatype) to run the proper extracts.

The Data Warehouse Sources dialog can help you track and report on the source for each data warehouse column. Specifying data warehouse sources helps you to document the relationships between your data warehouse data and the data in your OLTP systems. Table and column names and column datatypes can be imported from an .erwin file, a model located in a mart, database, DDL script, or comma-separated values (CSV) file and subsequently referenced as the data warehouse source. In addition, when you copy and paste objects between models, the data warehouse source information is automatically updated.

More information:

Create a Data Warehouse Source

Import a Data Warehouse Source

Add a Table to a Data Warehouse Source

Add a Column to a Data Warehouse Source

Remove a Table from a Data Warehouse Source

Remove a Column from a Data Warehouse Source