Background documentationRecommendations for Modeling the Data Flow

 

We recommend that you model the data flow in accordance with Data Warehouse layer architecture.

For information about layer architecture, see Architecture of a Data Warehouse.

You do not have to implement all four layers but can decide which structure best suits your needs.

Questions that are central to making this decision include:

  • Does the data come from heterogeneous source systems and therefore need to be consolidated first?

  • Do I need the data for operational data analysis?

  • Which questions do I want to answer by analyzing this data?