Data Modelling interview questions

Difference between DWH and Data mart, Difference between views and materialized views. What is Indexing and which kind of Indexing Technique we use in

What is BI, Which kind of modeling suitable for OLAP Reporting and WHY, Steps to create a Database,

What is CDC TECHNIQUE?, What is confirmed Dimension tell the scenario where u face, What is role playing Dimension, Types of Hierarchy

What is data sparsity and how it effect on aggregation?

Why are recursive relationships are bad? How do you resolve them?

What is First Normal Form

What is an artificial (derived) primary key? When should it be used?

What is ERD?

What is the difference between star flake and snow flake schema?

When should you consider denormalization?

Waht is second normal form

Describe the third normal form

Is this statement TRUE or FALSE ? all databases must be in third normal form?

What role views play in dimensional modeling?

What is normalization? Explain normalization types.

What is LIS ?

What is the difference between joins and scope relationship?

How can you apply linked list to improve your college's database?

What is fish-bone analysis?

What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?

What is the role of an QA?