general OLTP db and OLAP db question about conversion
Hi MOSC,
Typically to create a data warehouse (OLAP db) a shop will set up a dss db specifically set up for OLAP duties.
This data flow could shown in a simplified manner via;
OLTP-db ---> ETL processes ---> OLAP-db ---> Reports / BI
However, in general, are there any practices/reasoning for converting an existing OLTP db into an OLAP db as far as upgradie paths, migration paths, or other?
Thanks!
Best Regards,
Donald