As a data warehouse professional you are faced with some trade-offs. One of them is speed versus space. The article below shares some interesting facts about applying compression to tables. It indicates the affect page compression has on bulk load times vs table size.
What is required is to balance load times (speed) vs disk storage (space).
Page compression consistently returns the fastest query response times.
My DWH suggestion: load into heap and add clustered index with page compression afterwards.
What’s your thoughts?
*Image provided is from Microsoft.