Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What is the syntax for case when statement?

1085

What are the steps to create a data model?

1003

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

1127

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

956

What are report filters and view filters?

914

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

843

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

895

How do users receive only information that they want?

945

What is the difference between absolute filtering and standard filtering?

990

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

897

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

969

Difference between project merge and object manager?

975

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

914

What are the supported languages for microstrategy intelligence server?

979

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

1001

Un-Answered Questions { Data Warehouse }

What is a real-time data warehouse?

965

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4542

What are the co> operating system’s assorted library of integrated components?

1085

How we can use union transformation?

1016

Difference between sequential file and data set?

1158

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

905

Explain confirmed dimensions. When are they used?

947

What is the difference between drill through, drill across?

1042

What is the information present in the cognos configuration file?

924

describe the interaction table in sas di? : Sas-di

992

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1025

What is a compound attribute in microstrategy?

1000

explain one complex mapping with logic? sales project?

6627

How a server job can be converted to a parallel job?

1063

what is epilog tab?

For More Un-Answered { Data Warehouse } Questions Click Here