Data Modelling Interview Questions and Answers
Ques:- Difference between DWH and Data mart, Difference between views and materialized views. What is Indexing and which kind of Indexing Technique we use in
Ques:- What is BI, Which kind of modeling suitable for OLAP Reporting and WHY, Steps to create a Database,
Ques:- What is CDC TECHNIQUE?, What is confirmed Dimension tell the scenario where u face, What is role playing Dimension, Types of Hierarchy
Ques:- What is data sparsity and how it effect on aggregation?
Ques:- Why are recursive relationships are bad? How do you resolve them?
Ques:- What is First Normal Form
Ques:- What is an artificial (derived) primary key? When should it be used?
Ques:- What is ERD?
Ques:- What is the difference between star flake and snow flake schema?
Ques:- When should you consider denormalization?
Ques:- Waht is second normal form
Ques:- Describe the third normal form
Ques:- Is this statement TRUE or FALSE ? all databases must be in third normal form?
Ques:- What role views play in dimensional modeling?
Ques:- What is normalization? Explain normalization types.
Ques:- What is LIS ?
Ques:- What is the difference between joins and scope relationship?
Ques:- How can you apply linked list to improve your college’s database?
Ques:- What is fish-bone analysis?
Ques:- What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
Ques:- What is the role of an QA?