Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is the difference between constraind base load ordering and target load plan?

631

How to add a number to a macro variable?

541

What is the difference between drill through and masterdetail reports?

527

What is the difference between narmal load and bulk load?

1 684

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

521

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

507

How many types of facts and what are they?

541

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

530

Why we use repository connectivity?

532

The same tier?

531

What is recovering sessions?

532

How to define a cube??

534

What is prompt types of prompts?use of prompts syntax of prompt?

648

How to drill through from a powerplay cube to reportnet?

491

What is load manager?

553


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

697


What are diagrams?

611


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

642


What needs to be done when the database is shutdown?

538


What are the different types of data warehousing?

503






What are situations where snow flake schema is better than star schema to use and when the opposite is true?

518


What is the difference between static cache and dynamic cache?

508


How can you import tables from a database?

536


Explain what are the tasks that loadmanger process will do?

477


What are the stages of datawarehousing?

530


What are the types of dimensional modeling?

597


How to calculate fact table granularity?

565


How to test report in reportnet?

555


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

550


How many types of facts and what are they?

541