Dimension Tables

Dimension Table: Dimension table is one that describe the business entities of an enterprise, represented as hierarchical, categorical information such as time, departments, locations, and products. Dimension tables are sometimes called lookup or reference tables. Location Dimension: In a relational data modeling, for normalization purposes, country lookup, state lookup, county lookup, and city lookups are not merged as…

Read More

Data Modeling Frequently Asked Interview Questions And Answers – Part 1

The following data modeling questions and answers are conceptual questions that are asked during the data modeler interview.  1. What is data modeling? A data model is a conceptual representation of business requirement (logical data model) or database objects (physical) required for a database and are very powerful in expressing and communicating the business requirements…

Read More
error: Content is protected !!