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?

990

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

968

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.

1036

Ist the schema that a data warehouse system can implements.

892

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

916

What is drill-through?

940

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

873

Store (and count) non-fact records?

887

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

891

Define data warehouse?

990

How to pivot row data using informatica?

891

Why null values are mapped as 0 in fact tables?

966

What are the differences between datamart vs. Reporting cube?

1053

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

949

List any five applications of data warehouse.

916

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the different models used in cluster analysis?

921

How to add a number to a macro variable?

955

What are the data types present in bo?

1074

what is difference between drill & scope of analysis?

1019

Explain if a flat file cotains 1000 records how can I get first and last records only?

898

What is perform recovery?

1030

What is crass reference table?

1020

Tell me what is full load & incremental or refresh load?

909

Explain difference between data ware house & data mart?

953

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

971

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

1100

What is the purpose of cluster analysis in data warehousing?

967

explain about balanced dimension,

939

What is surrogate key? Where we use it? Explain with examples.

982

Explain what are data marts?

1065

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