Data WareHousing Interview Questions

[mustafa]

What are types of Facts?
Categories: Data WareHousing Interview Questions

What are non-additive facts in detail?
Categories: Data WareHousing Interview Questions

What is the difference between view and materialized view?
Categories: Data WareHousing Interview Questions

Why should you put your data warehouse on a different system than your OLTP system?
Categories: Data WareHousing Interview Questions

What are conformed dimensions?
Categories: Data WareHousing Interview Questions

What are Data Marts?
Categories: Data WareHousing Interview Questions
What is ETL?
Categories: Data WareHousing Interview Questions

What does level of Granularity of a fact table signify?
Categories: Data WareHousing Interview Questions

What is the Difference between OLTP and OLAP?
Categories: Data WareHousing Interview Questions

What are non-additive facts?
Categories: Data WareHousing Interview Questions

What are slowly changing dimensions?
Categories: Data WareHousing Interview Questions

Why are OLTP database designs not generally a good idea for a Data Warehouse?
Categories: Data WareHousing Interview Questions

What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Categories: Data WareHousing Interview Questions