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?

971

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

942

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.

1005

Ist the schema that a data warehouse system can implements.

863

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

889

What is drill-through?

924

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

856

Store (and count) non-fact records?

858

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

869

Define data warehouse?

963

How to pivot row data using informatica?

873

Why null values are mapped as 0 in fact tables?

943

What are the differences between datamart vs. Reporting cube?

1027

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

922

List any five applications of data warehouse.

885

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between olap and oltp?

967

What is the purpose of cluster analysis in data warehousing?

943

How to improve session performance in aggregator transformation?

930

What are the key features of chameleon that separates it from other algorithms?

1059

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5599

Explain what is type 2 version dimension?

935

How can we determine what records to extract?

1024

What is cfapplication tag?

910

What is a fact, dimension, measure?

1085

What is data cleaning? How can we do that?

980

What are the different types of data warehousing?

887

How can we run the graph?

993

What are steps we have to follow in designing the userfriendly universe?

919

How to add a number to a macro variable?

937

What is surrogate key? Where we use it?

930

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