Data Warehouse Interview Questions and Answers
Question - 31 : - What is Metadata?
Answer - 31 : -
Metadata is defined as data about the data. The metadata contains information like number of columns used, fix width and limited width, ordering of fields and data types of the fields.
Question - 32 : - What are loops in Datawarehousing?
Answer - 32 : -
In datawarehousing, loops are existing between the tables. If there is a loop between the tables, then the query generation will take more time and it creates ambiguity. It is advised to avoid loop between the tables.
Question - 33 : - Whether Dimension table can have numeric value?
Answer - 33 : -
Yes, dimension table can have numeric value as they are the descriptive elements of our business.
Question - 34 : - What is the definition of Cube in Datawarehousing?
Answer - 34 : -
Cubes are logical representation of multidimensional data. The edge of the cube has the dimension members,and the body of the cube contains the data values.
Question - 35 : - What is called Dimensional Modelling?
Answer - 35 : -
Dimensional Modeling is a concept which can be used by dataware house designers to build their own datawarehouse. This model can be stored in two types of tables – Facts and Dimension table.
Fact table has facts and measurements of the business and dimension table contains the context of measurements.
Question - 36 : - What are the types of Dimensional Modeling?
Answer - 36 : -
There are three types of Dimensional Modeling and they are as follows:
- Conceptual Modeling
- Logical Modeling
- Physical Modeling
Question - 37 : - What is surrogate key?
Answer - 37 : -
Surrogate key is nothing but a substitute for the natural primary key. It is set to be a unique identifier for each row that can be used for the primary key to a table.
Question - 38 : - What is the difference between ER Modeling and Dimensional Modeling?
Answer - 38 : -
ER modeling will have logical and physical model but Dimensional modeling will have only Physical model.
ER Modeling is used for normalizing the OLTP database design whereas Dimensional Modeling is used for de-normalizing the ROLAP and MOLAP design.
Question - 39 : - What are the steps to build the datawarehouse?
Answer - 39 : -
Following are the steps to be followed to build the datawaerhouse:
- Gathering business requirements
- Identifying the necessary sources
- Identifying the facts
- Defining the dimensions
- Defining the attributes
- Redefine the dimensions and attributes if required
- Organize the Attribute hierarchy
- Define Relationships
- Assign unique Identifiers
Question - 40 : - What are the different types of datawarehosuing?
Answer - 40 : -
Following are the different types of Datawarehousing:
- Enterprise Datawarehousing
- Operational Data Store
- Data Mart