Data Warehouse Interview Questions and Answers
Question - 21 : - What is the difference between Datawarehouse and OLAP?
Answer - 21 : -
Datawarehouse is a place where the whole data is stored for analyzing, but OLAP is used for analyzing the data, managing aggregations, information partitioning into minor level information.
Question - 22 : - What is ER Diagram?
Answer - 22 : -
ER diagram is abbreviated as Entity-Relationship diagram which illustrates the interrelationships between the entities in the database. This diagram shows the structure of each tables and the links between the tables.
Question - 23 : - What are the key columns in Fact and dimension tables?
Answer - 23 : -
Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of fact tables are the primary keys of the dimension tables.
Question - 24 : - What is SCD?
Answer - 24 : -
SCD is defined as slowly changing dimensions, and it applies to the cases where record changes over time.
Question - 25 : - What are the types of SCD?
Answer - 25 : -
There are three types of SCD and they are as follows:
SCD 1 – The new record replaces the original record
SCD 2 – A new record is added to the existing customer dimension table
SCD 3 – A original data is modified to include new data
Question - 26 : - What is BUS Schema?
Answer - 26 : -
BUS schema consists of suite of confirmed dimension and standardized definition if there is a fact tables.
Question - 27 : - What is Star Schema?
Answer - 27 : -
Star schema is nothing but a type of organizing the tables in such a way that result can be retrieved from the database quickly in the data warehouse environment.
Question - 28 : - What is Snowflake Schema?
Answer - 28 : -
Snowflake schema which has primary dimension table to which one or more dimensions can be joined. The primary dimension table is the only table that can be joined with the fact table.
Question - 29 : - What is a core dimension?
Answer - 29 : -
Core dimension is nothing but a Dimension table which is used as dedicated for single fact table or datamart.
Question - 30 : - What is called data cleaning?
Answer - 30 : -
Name itself implies that it is a self explanatory term. Cleaning of Orphan records, Data breaching business rules, Inconsistent data and missing information in a database.