Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Code the tables statement to produce a multi-level frequency?

64

Who needs data warehousing?

72

What is data mart in data warehouse?

65




What are the fundamental elements of the data warehouse?

71

Give some difference between oltp and olap.

95

Can you state some of the innovations throughout history?

62

What are cluster analysis in data warehousing?

68

What according to you might be the future of data warehousing?

85




What are various warehousing tools?

69

What is data analytics in simple terms?

68

What are the different types of data warehouses?

52

What are the design methods of data warehousing?

64

Name a few sectors which use data warehousing?

63

What are the other names given to data warehousing?

65

What are the reasons to use a chameleon method in data warehousing?

79


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

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

58


What is the difference between mapping parameter & mapping variable in data warehousing?

69


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1018


What is the use of tabular model, tabular sql, tabular reference in real time application?

69


Explain what are the mapping paramaters and maping variables?

78






How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

68


Explain what are the steps to build the data warehouse?

75


Explain what is the difference between powerplay transformer and power play reports?

67


Explain why fact table is in normal form?

66


What is dimensional modelling?

80


Explain the differences between normalizer and normalizer transformation?

68


What is Discrete and Continuous data in Data mining world?

1664


Explain what is the advantages data mining over traditional approaches?

94


What is surrogate key? Explain with examples.

78


Where we use surrogate key explain with example?

76