InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do You Identify What Are The Dimension Tables And How Do You Decide Them During The Business/data Modeling? |
|
Answer» Dimension tables contain descriptions that data ANALYSTS use as they query the database. For example, the Store table contains store names and addresses; the Product table contains product packaging information; and the Period table contains month, quarter, and YEAR VALUES. Every table contains a primary key that consists of one or more COLUMNS; each row in a table is uniquely identified by its primary-key value or values. Dimension tables contain descriptions that data analysts use as they query the database. For example, the Store table contains store names and addresses; the Product table contains product packaging information; and the Period table contains month, quarter, and year values. Every table contains a primary key that consists of one or more columns; each row in a table is uniquely identified by its primary-key value or values. |
|