Logical vs. Physical The logical design is more conceptual and abstract than the physical design. In the logical design , you look at the logical relationships among the objects. In the physical design , you look at the most effective way of storing and retrieving the objects. Your design should be oriented toward the needs of the end users. End users typically want to perform analysis and look at aggregated data, rather than at individual transactions. Your design is driven primarily by end-user utility, but the end users may not know what they need until they see it. A well-planned design allows for growth and changes as the needs of users change and evolve. Type of Data Modeling? 1) Conceptual Data Model 2) Logical Data Model 3) Physical Data Model Conceptual Data Model - Design Step 1 This is First step for DWH Designing. Conceptual Data Model is the first step in Data Warehouse design. In conceptual data model, v...