12 May 20 · rajneesh4u · #general ·   Bookmark   ×

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

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




npackMay 12 11:37

I would say monitor the daily volume and weekly growth for you project and distribute the available space per the needs

rajneesh4uMay 15 08:56

Thank you !!!


Community Software by Hittly