Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is fact degradation?

564

What is report as filter in microstrategy?

523

What is smart metric?

539

Does microstrategy intelligence server run on windows®, unix®, or linux®?

536

What is non-aggregate metric?

555

What are the types of facts in microstrategy?

613

What is the difference between absolute filtering and standard filtering in microstrategy?

559

What information is shared by the application across microstrategy web nodes?

564

What is percent-to-total shortcut metric in microstrategy?

540

What are the different types of metrics available in microstrategy?

533

What are vldb properties in microstrategy?

573

What is a compound attribute in microstrategy?

608

What is the conflict resolution window?

589

Can schema objects be copied across projects with microstrategy object manager?

540

How do we resolve attribute roles in microstrategy?

675


Un-Answered Questions { Data Warehouse }

How can I run the 2 gui merge files?

690


Slowly changing dimensions, types and where will you use them

1264


What are constraints and derivations?

641


What is the difference between fastload and multiload?

786


In informatica workflow manager, how many repositories can be created?

774






What is load manager?

563


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

566


What is the command line function to import and export the ds jobs?

675


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1508


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

532


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

617


Explain vproc in teradata?

559


If a variable contains letters or special characters, can it be numeric data type?

755


What is the main difference between schema in rdbms and schemas in datawarehouse?

535


explain the concepts and capabilities of business object? : Sas-bi

536