Question
Surrogate keys are used in data warehouses because:
More Data Warehousing Questions
- In a data warehouse, which type of table stores quantitative data for analysis?
- What is meant by 'cardinality' in data modeling?
- Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
- Which type of OLAP allows operations on pre-aggregated data cubes?
- A Fact Constellation Schema is also called:
- Which type of data warehouse is focused on specific business lines or departments?
- Which of the following is NOT a common OLAP operation?
- ETL stands for:
- In a star schema, what is the main advantage of using surrogate keys in fact tables?
- Which schema in data warehousing uses a central fact table connected to dimension tables?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)