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?

1143

What are the steps to create a data model?

1053

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

1169

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

992

What are report filters and view filters?

958

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

915

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

938

How do users receive only information that they want?

981

What is the difference between absolute filtering and standard filtering?

1050

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

924

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

1013

Difference between project merge and object manager?

1020

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

959

What are the supported languages for microstrategy intelligence server?

1011

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

1063

Un-Answered Questions { Data Warehouse }

What are the data marts?

975

How to test a cube?

2192

What is a standalone command task?

1204

What is the advantage of using shortcuts?

1183

What are types of batch available in cognos?

974

What does proc print, and proc contents are used for?

1136

What is a security filter in microstrategy?

1021

What is PROC in SAS?

1058

What are the join problems comes appart from loop,chasm & fan Traps

2132

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

900

What is the maplet?

1119

how many types of dimensions are available in informatica?

1099

What is cubes?

1072

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1004

What are the ways to import data into catalog?

1084

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