Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

72

In a star schema, are foreign key constraints between facts and dimensions neccessary?

58

Fact table is in normalized or de-normalized form?

64




How can we do data cleaning?

70

What are fundamental stages of data warehousing?

60

What are aggregate tables and aggregate fact tables?

60

What is vldb(very large databases)?

71

What is the difference between view materialized view and view?

71




Explain datawarehousing?

62

What is operational data store (ods)?

68

Explain dimension table ?

68

What is bi?

58

Explain is fact table?

59

What are vaious etl tools in the market?

60


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

71


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

75


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

64


How to export mappings to the production environment?

71


What are target types on the server?

65






What are Non-additive facts?

100


Briefly state different between data ware house & data mart?

75


What are the design methods of data warehousing?

64


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

72


What is a fact, dimension, measure?

64


What are the data types present in bo? What happens if we implement view in the designer n report?

73


What is the use of dimensional modeling in data warehousing?

66


What is the difference between view filter and report filter?

71


Which columns go to the fact table and which columns go the dimension table?

67


what is difference between drill & scope of analysis?

73