Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

760

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

710

Fact table is in normalized or de-normalized form?

716

How can we do data cleaning?

762

What are fundamental stages of data warehousing?

716

What are aggregate tables and aggregate fact tables?

674

What is vldb(very large databases)?

678

What is the difference between view materialized view and view?

783

Explain datawarehousing?

737

What is operational data store (ods)?

722

Explain dimension table ?

713

What is bi?

746

Explain is fact table?

664

What are vaious etl tools in the market?

722


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

846


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

657


Explain Association algorithm in Data mining?

2024


Explain what is metadata reporter?

716


What is VLDB?

769






Whether dimension table can have numeric value?

739


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

708


What is Discrete and Continuous data in Data mining world?

2288


Explain the importance of data warehouse?

723


Explain what is the advantages data mining over traditional approaches?

764


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

745


What are parallel querys and query hints?

1928


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

667


Explain what are the advantages and disadvantages of reporting directly against the database?

742


What are data modeling and data mining?

801