Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

573

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

533

Fact table is in normalized or de-normalized form?

535

How can we do data cleaning?

577

What are fundamental stages of data warehousing?

527

What are aggregate tables and aggregate fact tables?

518

What is vldb(very large databases)?

536

What is the difference between view materialized view and view?

580

Explain datawarehousing?

548

What is operational data store (ods)?

554

Explain dimension table ?

551

What is bi?

558

Explain is fact table?

504

What are vaious etl tools in the market?

560


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is drilling across?

552


What are the steps of implementing data warehousing?

524


What are the advantages of query studio compared to report studio?

496


What are the different types of segments?

534


What is metadata in context of a datawarehouse?

541






What is the difference between dependent data warehouse and independent data warehouse?

598


Explain degenerate dimension table?

533


What are data modeling and data mining?

645


What is data warehouse architecture?

571


What is the difference between drill through and masterdetail reports?

533


What is the function of etl when used in data warehousing?

533


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

522


What are the various file formats involved in reportnet?

532


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?

518


Explain what are the advantages data mining over traditional approaches?

670