Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Code the tables statement to produce a multi-level frequency?

557

Who needs data warehousing?

573

What is data mart in data warehouse?

543

What are the fundamental elements of the data warehouse?

508

Give some difference between oltp and olap.

603

Can you state some of the innovations throughout history?

560

What are cluster analysis in data warehousing?

568

What according to you might be the future of data warehousing?

536

What are various warehousing tools?

588

What is data analytics in simple terms?

564

What are the different types of data warehouses?

584

What are the design methods of data warehousing?

521

Name a few sectors which use data warehousing?

527

What are the other names given to data warehousing?

652

What are the reasons to use a chameleon method in data warehousing?

574


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the advantages and disadvantages of reporting directly against the database?

551


Explain what are necessary tasks to install reportnet software?

499


what are the other factors of the database on which the loading performance depend?

1505


How to stop a batch?

555


What needs to be done while starting the database?

664






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

546


Explain how many ways you create ports?

619


In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

601


what are the all possible features supported modify stage?

1620


Explain what is the difference between powerplay transformer and power play reports?

648


Explain the difference between view and materialized view?

520


How can you set the client management?

579


Explain datawarehousing?

563


What is the use of tabular model, tabular sql, tabular reference in real time application?

530


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

524