Thank you for your response

We are not sure yet whether to create it as clustered or not. This is something we will need to test with.

The deletes will happen through a daily ETL data load. In some cases we may have more than one loads per day there are multiple fact tables we delete from.