Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is the syntax for case when statement?

787

What are the steps to create a data model?

786

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

813

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

748

What are report filters and view filters?

728

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

651

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

705

How do users receive only information that they want?

718

What is the difference between absolute filtering and standard filtering?

705

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

704

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

747

Difference between project merge and object manager?

776

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

690

What are the supported languages for microstrategy intelligence server?

778

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

798


Un-Answered Questions { Data Warehouse }

Is it possible to query a hash file?

1744


Describe the function and utility of the most difficult SAS macro that you have written?

2245


Difference between sequential file and data set?

855


Which command is used to save logs in the external file?

785


-------------How you design DWH?

2050


What are the different components of powercenter?

784


What function CATX syntax does?

861


What is the purpose of indexes?

783


what are the different authentication modes available in microstrategy?

800


What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1086


Separate from a database, an information bazaar, and an information stockroom?

811


How to select multiple values from type-in prompt?

823


What are the various file formats involved in reportnet?

721


What are the different ways to represent the loading of dimension tables?

683


how u will determine the performence tune will occur either in report or system

1887