Data Warehouse Designer Views

1.Top-Down View

• Allows the selection of relevant information necessary
• This information matches the current and coming business needs

2.Data Source View

• Exposes the information being captured, stored and managed by operational systems
• This view is often modeled by traditional data modellingtechniques such as ER Model or CASE tools

3.Data Warehouse View

• Includes fact tables and dimension tables
• Represents precalculated totals and counts
• Provides historical context

4.Business Query View

• It’s the perspective of a data in the warehouse from the viewpoint of the end user