Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

556

What are level metrics? Why are they needed?

592

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

576

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

538

Does microstrategy intelligence server support scheduling?

635

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

550

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

640

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

589

What security is provided with microstrategy desktop?

552

What does microstrategy desktop allow users to do?

516

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

597

Can I deploy a single bi application in multiple languages?

559

What is the order of precedence of vldb properties?

570

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

534

What subtotaling features does microstrategy desktop contain?

534


Un-Answered Questions { Data Warehouse }

What is the differences between star and snowflake schemas?

546


what is the use of skid in reporting?

1955


What are all the types of indexes in Cognos?

716


Where we use afc in actuate?

539


name the prompt which are available in cognos?

5






For what purpose would you use the RETAIN statement?

1045


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6409


explain the methodology of Data Warehousing?(Polaries)

1482


What is MPP in Redshift ?

5


when will use SQL override in a lookup transformation?

1877


Define tm1 architecture?

5


What is a joint child?

553


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

552


What is a joiner transformation and why it is an active one?

580


What does role playing dimension mean?

629