Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Systems that have both OLTP and OLAP databases periodically move data from the OLTP database to the OLAP database, so that reports can be generated based on the OLAP database.
What's the official term for this process and is there an overview of this process online?
It is mostly referred as ETL process (extraction, transformation, and load).
Here are a link of MSDN article on Transforming OLTP Data to OLAP Data Warehouses. It is an old article but the same concept applied.
Microsoft SQL Server Analysis Services uses the term "cube processing".
Kimball seems to usually use the term "dimensional model loading".
Accordingly, I use the term "ETL" to refer to copying data from the OLTP systems into the staging database (or for copying data from one OLTP database to another) and the term "cube processing" to refer to copying data from the staging database into the OLAP databases.
