Question
Which SQL keyword is used to combine results from two
queries and remove duplicates?Solution
UNION combines results from two queries and eliminates duplicate rows.
More Data Warehousing Questions
ETL stands for:
In a star schema, what is the main advantage of using surrogate keys in fact tables?
A snowflake schema differs from a star schema mainly because:
In a data cube, what does "slice" operation do?
ETL stands for:
Which of the following is used to maintain information about the structure of a data warehouse?
Which of the following stores historical data for analysis?
In a data warehouse, which type of table stores quantitative data for analysis?
Which process ensures data in a data warehouse is consistent and clean?
In OLAP, āSlice and Diceā means:
