Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the message flows?

642

Can you define bitmap index?

685

Can you define set to be cardinality?

667

Can you define metrics designer?

703

Can you define query studio?

646

What actually a project contains?

733

Can you define transformer?

615

Can you define a datastore in cognos?

681

Can you define cube?

691

Can you define dimension?

711

Can you define slice?

704

Can you define framework manager?

697

Can you define fan trap?

893

What is model filter?

717

Can you explain model durability?

689


Un-Answered Questions { Data Warehouse }

What are the features of SAS?

664


What is the difference between server job and parallel jobs?

790


What are the fundamental elements of the data warehouse?

580


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1710


How will you do different types of narrative reports in obiee?

609






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

675


What would you consider as your biggest achievement and why?

696


What are the important Features of Redshift?

5


Mention few power centre client applications with their basic purpose?

619


Explain how to generate iqd file from framework manager?

593


What is operational data store (ods)?

655


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

660


What are your responsibilities as an etl tester?

719


What is the use of code page?

691


how do u handle performance issues in Informatica . where can u monitor the performance ?

4352