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?

1048

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

1012

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.

1078

Ist the schema that a data warehouse system can implements.

942

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

972

What is drill-through?

992

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

905

Store (and count) non-fact records?

937

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

936

Define data warehouse?

1048

How to pivot row data using informatica?

967

Why null values are mapped as 0 in fact tables?

1008

What are the differences between datamart vs. Reporting cube?

1102

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

983

List any five applications of data warehouse.

943

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the difference between filter and conditin?

970

Explain what are necessary tasks to install reportnet software?

938

What is the difference between a primary and secondary actor in use case modeling?

1067

How can we schedule the graph in unix?

1002

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1057

What is data stream and data adaopter. Is it same are different? Explain?

1020

How to export mappings to the production environment?

911

What are the data marts?

984

What is data analysis? Where it will be used?

989

What is analytical or analytic mean?

1129

Explain bus schema?

981

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

934

What is an er diagram?

1054

What is the difference between er modeling and dimensional modeling?

1154

What is partitioning? What are the types of partitioning?

1172

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