Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What are the steps of implementing data warehousing?

1086

Explain about core dimension, balanced dimension, and dirty dimension?

1055

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1123

Ist the schema that a data warehouse system can implements.

993

What is the very basic difference between data warehouse and operational databases?

1031

What is drill-through?

1045

How to pivot data using informatica when you have variable amount of pivot rows?

952

Store (and count) non-fact records?

981

What is many-to-many dimensional model in datawarehousing ?

989

Define data warehouse?

1100

How to pivot row data using informatica?

1015

Why null values are mapped as 0 in fact tables?

1047

What are the differences between datamart vs. Reporting cube?

1159

What should I have in mind when building olap solution from scratch?

1056

List any five applications of data warehouse.

985

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the types of SCD?

1281

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2097

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

1012

What are the steps of implementing data warehousing?

1086

What is the difference between filter and lookup transformation?

1177

How can we run the graph? What is the procedure for that?

992

What is a data warehousing?

1226

What is the use of dimensional modeling in data warehousing?

1048

ware house management system is used?

1055

What is VLDB?

1112

Which are the olap tools available that are supported by oracle?

978

What needs to be done while starting the database?

1157

What are the stages of datawarehousing?

1047

What is factless fact tables?

1285

What is static and local variable?

1076

For More Un-Answered { Data Warehouse General } Questions Click Here