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 fact degradation?

976

What is report as filter in microstrategy?

917

What is smart metric?

968

Does microstrategy intelligence server run on windows®, unix®, or linux®?

970

What is non-aggregate metric?

1016

What are the types of facts in microstrategy?

1032

What is the difference between absolute filtering and standard filtering in microstrategy?

979

What information is shared by the application across microstrategy web nodes?

1047

What is percent-to-total shortcut metric in microstrategy?

977

What are the different types of metrics available in microstrategy?

974

What are vldb properties in microstrategy?

1044

What is a compound attribute in microstrategy?

1039

What is the conflict resolution window?

1042

Can schema objects be copied across projects with microstrategy object manager?

980

How do we resolve attribute roles in microstrategy?

1152

Un-Answered Questions { Data Warehouse }

What is the session task and command task?

1058

In banking domain how many Fact tables,Dimension table are present?

8801

what are several options for creating reports in web report studio? : Sas-bi

1155

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1537

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1061

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906

What do you understand by ‘ibm predictive maintenance and quality’?

993

Explain is olap databases are called decision support system true/false?

1005

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2238

What is main advantage datawarehousing over oracle?

1004

Which component has onread method and what it is used for?

984

How many steps etl contains explain with example?

970

What is microstrategy intelligence server?

1035

What are data modeling and data mining?

1085

What is the difference between fastload and multiload? Which one is faster?

1223

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