Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

643

How to add a number to a macro variable?

550

What is the difference between drill through and masterdetail reports?

538

What is the difference between narmal load and bulk load?

1 699

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

529

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

512

How many types of facts and what are they?

549

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?

540

Why we use repository connectivity?

540

The same tier?

540

What is recovering sessions?

538

How to define a cube??

546

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

662

How to drill through from a powerplay cube to reportnet?

498

What is load manager?

563


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the structure of cold fusion?

585


What is a hash cluster?

518


What is the difference between Datawarehouse and OLAP?

530


Can you state some of the innovations throughout history?

546


I have two universes created by two difference database can we join them in designer & report level? How

530






What is a linked cube?

537


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

527


What are the different types of data warehouses?

569


Explain what are conformed dimensions?

566


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262


What is data analytics in simple terms?

551


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

639


What is the difference between agglomerative and divisive hierarchical clustering?

647


How to pivot data using informatica when you have variable amount of pivot rows?

517


How can we run the graph? What is the procedure for that?

503