Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain what are the advantages data mining over traditional approaches?

687

Explain er diagram?

555

Explain what are the vaious etl tools in the market?

493

Explain what are the steps to build the data warehouse?

488

What are the data marts?

526

Explain conformed fact?

529

Explain the difference between view and materialized view?

512

What are the vaious etl tools in the market?

1 1791

Explain bus schema?

549

Explain what are the possible data marts in retail sales?

508

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

530

Explain differences between star and snowflake schemas?

543

Explain vldb?

633

What is incremintal loading?

577

Explain hybrid slowly changing dimension?

576


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How did you plan your Data ware house project?

1784


What is the 4 + 1 view model as it relates to system modeling?

605


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?

506


What is Discover and Execute in XMLA?

1790


What are the different types of schemas used in data warehousing?

520






What is cost benefit analysis (cba)?

589


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

543


How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

592


Explain what is the difference between olap and datawarehosue?

608


What are fact, dimension, and measure?

775


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

559


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1541


Explain what are the advantages data mining over traditional approaches?

687


How to drill through from a powerplay cube to reportnet?

502


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

540