Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

654

How to add a number to a macro variable?

560

What is the difference between drill through and masterdetail reports?

549

What is the difference between narmal load and bulk load?

1 712

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

542

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

530

How many types of facts and what are they?

558

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?

549

Why we use repository connectivity?

550

The same tier?

551

What is recovering sessions?

554

How to define a cube??

557

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

674

How to drill through from a powerplay cube to reportnet?

508

What is load manager?

572


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between mapping parameter & mapping variable in data warehousing?

564


Why is chameleon method used in data warehouse?

703


What is the use of dimensional modeling in data warehousing?

547


What are data modeling and data mining? Where it will be used?

552


How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

539






Explain what are the advantages and disadvantages of reporting directly against the database?

582


Can we start and stop single session in concurent bstch?

536


Explain bus schema?

558


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

528


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

545


What is a relationship?

582


What is Sequence clustering algorithm?

1552


Explain piconet?

555


What is edw?

633


Explain what are conformed dimensions?

576