What is a dimension table in a data warehouse?
Correct Answer: Dimension table woh hoti hai jo descriptive attributes rakhti hai.
- Step 1: Understand that a data warehouse is a system used for reporting and data analysis.
- Step 2: Know that data in a data warehouse is organized into tables.
- Step 3: Identify that there are two main types of tables: fact tables and dimension tables.
- Step 4: Recognize that fact tables store numerical data or measurements (like sales amounts).
- Step 5: Learn that dimension tables store descriptive information (like product names or customer details) that help explain the facts.
- Step 6: Realize that dimension tables provide context to the data in fact tables, making it easier to understand and analyze.
No concepts available.
