Capacity planning for Compose Data Warehouse and Data Marts
We have a data source in Oracle. We are creating a Replica DB in SQL server using Replicate. From the Replica DB we are creating a Data Warehouse(DW_DB) and a Data Mart(DM_DB) using Compose.
How do we forecast the data storage requirements (for DW_DB and DM_DB)based on the source data volume , number of ETL jobs, etc we have.