Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is fact extension?

594

Explain the Roles in mstr?

543

How does microstrategy object manager integrate with the microstrategy product suite security model?

555

What is dynamic aggregation in microstrategy?

557

What is scanmd and md doctor?

641

Can the administrator easily maintain and manage microstrategy intelligence server?

547

What is derived metric?

586

What is a security filter in microstrategy?

563

What are logical views used for in microstrategy?

531

What are public objects?

637

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

561

How conflicts occur and what are the ways to resolve them?

531

What are configuration objects?

601

What are the enhanced features in teradata v2r5 and v2r6?

693

Explain Teradata performance tuning and optimization?

701


Un-Answered Questions { Data Warehouse }

how to export or import the jobs in .ISX file

718


What is workflow monitor?

596


What is cubes?

619


Explain the different types of views used in cognos.

507


How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

546






What do the PUT and INPUT functions do?

777


What is dynamic aggregation in microstrategy?

557


Explain what is full load & incremental or refresh load?

535


What is the difference between writing a joiner query in ANSI style and THETA style?

1917


what is operational data and operational system? : Sas-di

633


What are the main steps to build the data warehouse?

661


What are the updated features of teradata?

580


When can we choose the Redshift ?

5


Difference between zabo and webi?

638


Explain the special input delimiters used in sas programming.

583