Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is the syntax for case when statement?

582

What are the steps to create a data model?

593

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

567

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

558

What are report filters and view filters?

548

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

489

How can the user determine the object id of an object?

513

How do users receive only information that they want?

529

What is the difference between absolute filtering and standard filtering?

513

What olap capabilities do I have within a microstrategy report services document?

527

How long does it take to get microstrategy desktop up and running?

548

Difference between project merge and object manager?

564

How can users design dashboards quickly and without programming experience or training?

521

What are the supported languages for microstrategy intelligence server?

572

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

598


Un-Answered Questions { Data Warehouse }

where we cannot use sorter Transformation. if we use then we will not get correct data?

1797


What are the steps involved in designing a fact table?

486


Explain usage analysis in datastage?

644


How to drill through from a powerplay cube to reportnet?

495


What are the types of views in datastage director?

1239






Explain how spool space is used.

610


Tell e how how dealt with..

1751


-----------With out using DrillThrough how to do Reports?

1596


What is operational data store (ods)?

555


Explain about the data integration suite features?

467


What is the difference in the way microstrategy handles custom group and consolidations?

557


Name a few sectors which use data warehousing?

518


What is junk dimension? What is the difference between junk dimension and degenerated dimension?

585


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1729


How do you add a number to a macro variable? : sas-macro

538