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?

914

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?

1060

Un-Answered Questions { Data Warehouse }

What is a Folder?

1170

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1806

Explain what does dependency analysis mean in abinitio?

1141

What would you consider as your biggest achievement and why?

1012

How can you set the session management?

1120

What is transformation?

1099

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2063

what is session partitioning?

1879

Write the different types of matrices in microstrategy?

1014

Explain sessions?

1056

What is dtm?

1169

please please give me some banking calculations in framework manager.

2085

Differentiate between Load Manager and DTM?

2153

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

What is the difference between passive stage and active stage?

1538

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