The FIRST stage to build a data warehouse is the initial data introduction, typically this can be achieved by copying some OPERATIONAL database. This is called and offline operational database. Then, we have to FEED new sets of data to the NEWEST created data warehouse. Therefore, this database is updated with large sets of data in a regular time basis (week, month). With this step, we’ve successfully built a offline data warehouse.
To ACHIEVE a Real-time data warehouse you have to insert the operational data in real time. When this is integrated with the application, reporting on the data, it’s called a Integrated data warehouse.

The first stage to build a data warehouse is the initial data introduction, typically this can be achieved by copying some operational database. This is called and offline operational database. Then, we have to feed new sets of data to the newest created data warehouse. Therefore, this database is updated with large sets of data in a regular time basis (week, month). With this step, we’ve successfully built a offline data warehouse.
To achieve a Real-time data warehouse you have to insert the operational data in real time. When this is integrated with the application, reporting on the data, it’s called a Integrated data warehouse.