Contributor: Sakshi Jindal
What is data warehousing?
Our product runs on OLTP databases, Postgres and Mysql, which do not lend them to analytics. Warehousing is moving data from different OLTP(online transactional processing) sources to OLAP(online analytical processing) source, which is Amazon Redshift in our case. This ETL (Extraction, Transformation and Loading) process creates a layer optimised for and dedicated to analytics.Read More›