Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is the syntax for case when statement?

566

What are the steps to create a data model?

578

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

556

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

547

What are report filters and view filters?

536

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

474

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

505

How do users receive only information that they want?

518

What is the difference between absolute filtering and standard filtering?

499

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

516

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

536

Difference between project merge and object manager?

552

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

511

What are the supported languages for microstrategy intelligence server?

551

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

588


Un-Answered Questions { Data Warehouse }

Define bulk load mode?

5


What are the components used in smp and massively parallel processing (mpp) machines?

568


What are the design features involved in teradata?

524


what is INFORMATICA TESTING process

1814


Does AWS Redshift use SQL?

5






Differentiate between data file and descriptor file?

593


How create measures and demensions?

570


Which transformation we use to convert 'NA' to 'Not Available'

837


What is the use of stop statement?

611


difference between informatica 8.1.1 and 8.6

3222


1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2131


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1664


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6013


what are the facilities provided by data warehouse to analytical users?

1651


Explain what is the difference between view filter and report filter?

553