Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

652

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

602

Fact table is in normalized or de-normalized form?

621

How can we do data cleaning?

655

What are fundamental stages of data warehousing?

606

What are aggregate tables and aggregate fact tables?

581

What is vldb(very large databases)?

597

What is the difference between view materialized view and view?

666

Explain datawarehousing?

620

What is operational data store (ods)?

635

Explain dimension table ?

612

What is bi?

643

Explain is fact table?

570

What are vaious etl tools in the market?

635


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the advantages of raid 1, 1/0, and

600


explain about balanced dimension,

616


Explain what is the difference between a primary and secondary actor in use case modeling?

730


Explain the main differences between star and snowflake schema?

598


What are the steps involved in creating dimensional modeling process?

629






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

622


Explain the difference between dw and bi?

577


Explain why denormalization is promoted in universe designing?

601


What is dimension modeling?

587


ware house management system is used?

629


what are the all possible features supported modify stage?

1664


Why fact table is in a normal form?

610


How to performance tune reports?

636


What is meta data and system catalog?

1911


Is union transormation is active transformation?

642