Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

776

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

731

Fact table is in normalized or de-normalized form?

734

How can we do data cleaning?

772

What are fundamental stages of data warehousing?

740

What are aggregate tables and aggregate fact tables?

699

What is vldb(very large databases)?

708

What is the difference between view materialized view and view?

805

Explain datawarehousing?

765

What is operational data store (ods)?

744

Explain dimension table ?

733

What is bi?

757

Explain is fact table?

685

What are vaious etl tools in the market?

743


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a source qualifier?

757


What is the difference between star and snowflake schemas?

816


Explain what is batch and describe about types of batches?

789


Explain what is the difference between power center & power mart?

713


What is degenerate dimension table?

745


What is is a star schema?

761


What is cubes?

808


Explain what are the various methods of getting incremental records or delta records from the source systems?

708


What is batch processing?

765


Explain what are the methodologies of data warehousing?

679


What function should we use to display the value entered or selected by a user in response to a prompt?

695


What are the different types of data warehouses?

768


What is defined as partial backup?

802


Can we start and stop single session in concurent bstch?

698


What is the difference between junk dimension and degenerated dimension?

733