Any general guidelines to allocate table space quota to different layers in ETL?

Hello Experts,

I am looking for any general guidelines to allocate table space quota to different layers/schemas in ETL flow of a data warehouse (% of total space in each layer).

I have these 4 layers:

1. Staging -truncate and load data from source files

2. ODS- Type 1 persistent tables

3. Transformation layer- similar to final DWH layer but truncate before loading newly arrived data

4. DWH layer- Final dimensional model layer

I understand space requirement may vary based on project requirements, however still any general guideline (if any such in data warehousing and ETL space) to estimate the space will be helpful.

Thanks,

Rajneesh

rajneesh4u

posted on 12 May 20