Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

780

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

733

Fact table is in normalized or de-normalized form?

735

How can we do data cleaning?

774

What are fundamental stages of data warehousing?

740

What are aggregate tables and aggregate fact tables?

701

What is vldb(very large databases)?

711

What is the difference between view materialized view and view?

805

Explain datawarehousing?

766

What is operational data store (ods)?

746

Explain dimension table ?

734

What is bi?

760

Explain is fact table?

687

What are vaious etl tools in the market?

743


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is difference between query studio and report studio?

746


What is Star Schema?

845


What are the data types present in bo? What happens if we implement view in the designer n report?

723


Why is dimensional normalization not required?

829


Explain the differences between normalizer and normalizer transformation?

699


Explain bus schema?

708


Explain the importance of data warehouse?

753


How to get the first 100 rows from the flat file into the target?

906


Explain what is the extension of file to save template?

703


What is difference between query studio and report studio?

721


I need a good brd and uc template?

774


What is a core dimension?

791


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

732


Explain what is the difference between stop and abort?

743


Can you state some of the innovations throughout history?

732