Dimensional Data Modeling Interview Questions. Customers, products, manufacturers, and sellers are potential entities. 3.database performance, indexing strategy, and physical storage are important parameters of a physical model.

Conformed dimensions are those that are used across multiple areas, for example, with several tables in a database. Junk dimensions are those that aren’t otherwise found in a fact. They work closely with data architects to implement database systems to improve enterprise information management.