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

How can we run the graph?

993

In a star schema, are foreign key constraints between facts and dimensions neccessary?

929

Fact table is in normalized or de-normalized form?

906

How can we do data cleaning?

984

What are fundamental stages of data warehousing?

985

What are aggregate tables and aggregate fact tables?

962

What is vldb(very large databases)?

941

What is the difference between view materialized view and view?

1021

Explain datawarehousing?

997

What is operational data store (ods)?

955

Explain dimension table ?

920

What is bi?

1013

Explain is fact table?

875

What are vaious etl tools in the market?

938

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is real-time datawarehousing?

964

What is data analysis? Where it will be used?

919

What is data cleaning? How can we do that?

980

how much memory space occupied real time project (roughly)?

2177

How to design file watch jobs?

926

Explain difference between snow flake and star schema.

958

I need to set predefined condition. How I do this?

954

What are session timeout and application timeout? Where we have to do this process?

974

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2055

What is the difference between power center & power mart?

924

What is Operational Data Store?

1003

What is latest version of power center / power mart?

987

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

854

What is surrogate key? Where we use it explain with example?

858

Explain what are fact, dimension, and measure?

930

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