Catalog Database

The catalog database, located on the data warehouse server, is a view of all data sources, independent of source system. Most transformations from the original database structures are made in the catalog.

You can define more that one catalog. This allows you to create additional DWD solutions in the same repository. Composers, models and model groups are catalog oriented. A source/operational system and a data mart exist outside and are independent of the catalog.