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?

1044

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

1007

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.

1075

Ist the schema that a data warehouse system can implements.

940

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

964

What is drill-through?

985

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

904

Store (and count) non-fact records?

931

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

933

Define data warehouse?

1039

How to pivot row data using informatica?

953

Why null values are mapped as 0 in fact tables?

1004

What are the differences between datamart vs. Reporting cube?

1097

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

983

List any five applications of data warehouse.

939

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is difference between query studio and report studio?

988

What is batch processing?

1030

What are the design methods of data warehousing?

948

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

904

Explain me what is vldb?

933

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

911

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1102

what are relationships?

1047

Explain ddl (data definition language)?

1006

Is there any rownum object from which we can do this?

945

Explain what is a three tier data warehouse?

975

How to handle multi value dimensions?

2287

What is your spectra photometer working principles?

982

Explain degenerate dimension table?

1046

What is real-time datawarehousing?

1019

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