1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the vldb properties? Which level of vldb configurations have the highest precedence?

 550

What are level metrics? Why are they needed?

 583

How does microstrategy object manager determine if two objects in different projects are the same?

 572

At which levels you can set the vldb properties? Which level has the highest pecedence?

 532

Does microstrategy intelligence server support scheduling?

 633

What leads to a cross-join or how does a cross-join occur?

 546

How can you make the sql query to be based on a specific table of your choice?

 635

To save time, can many reports be run at the same time?

 586

What security is provided with microstrategy desktop?

 544

What does microstrategy desktop allow users to do?

 512

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

 589

Can I deploy a single bi application in multiple languages?

 557

What is the order of precedence of vldb properties?

 566

What specific features and functionality do I get with olap services?

 530

What subtotaling features does microstrategy desktop contain?

 532

Un-Answered Questions { Data Warehouse }

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1737

What is the size of the cube?

531

Is there any difference in testing database and data ware housing?

2268

can we perform checkin and checkout through sandbox?

715

Explain the difference between dw and bi?

509




What is the difference between an operational datastage and a data warehouse?

623

Difference between inner join and outer join?

578

Differentiate between sas functions and sas procedures.

635

------------- How to identify the Revenue Column in Report?

1812

design of staging area?

1581

How will I be charged and billed if I use Amazon Redshift?

5

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

527

Explain the Roles in mstr?

540

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1624

How to configure mapping in informatica?

672

For More Un-Answered { Data Warehouse } Questions Click Here