The Data Warehouse Center can store data in any DB2 database, including DB2 Universal Database for iSeries and DB2 Universal Database for z/OS and OS/390, as well as in flat files.

Several Data Warehouse Center mechanisms can be used to populate the data warehouse. You can use the SQL processing capability of the database engine to select the desired data from the source or sources, transfer the data to the target database, and transform the data on insert. Stored procedure invocations of transformations at the target allow further data transformation.