Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is Active Datawarehousing?

554

What is the difference between Datawarehouse and OLAP?

525

What is called data cleaning?

610

What is factless fact tables?

629

What is the difference between metadata and data dictionary?

575

What are the tools available for etl?

535

What is the goal of optimizer?

578

What are the different types of datawarehosuing?

552

What are the approaches used by optimizer during execution plan?

474

What needs to be done while starting the database?

646

What is the definition of cube in datawarehousing?

549

What is the difference between er modeling and dimensional modeling?

587

What is defined as partial backup?

618

What are the stages of datawarehousing?

532

What is called dimensional modelling?

572


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

504


What is Star Schema?

635


What is the main difference between star and snowflake star schema? Which one is better and why?

546


for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1668


Explain can a dimension table contains numeric values?

554






Explain what are components of report studio?

562


List any five applications of data warehouse.

546


What is an er diagram?

623


Explain me what are conformed dimensions?

536


Explain meta data?

542


What is the difference between filter and lookup transformation?

599


What is the difference between power center & power mart?

496


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

495


What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

510


What is the metadata extension?

533