Oracle Interview Question

Detailed step by step process involved in designing a custom warehouse