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 happens if the owner of an object does not exist in the destination project?

919

Can microstrategy desktop access operational data systems?

1070

What are attribute roles?

978

Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

985

Can I access intelligent cubes without olap services?

1048

Can intelligence server integrate with my existing data structure?

1061

How do you ensure simultaneous releases across multiple operating systems?

973

Can reports be executed in off-peak periods?

997

Can microstrategy desktop access sap data?

948

How is the number of passes in a sql query significant in performance evaluation?

969

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Is microstrategy desktop available in other languages?

1010

what is the difference between microstrategy and cognos?

928

what specific features and functionality do you get with olap services?

966

What are consolidations?

908

Un-Answered Questions { Data Warehouse }

What are data-driven sessions?

1213

What is data warehouse architecture?

1050

How to reverse the string using SQL?

1533

What are default access rights in teradata?

1124

What is orabulk stage?

1047

State the limitations where we cannot use joiner in the mapping pipeline?

1067

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1184

List out some of the primary characteristics of teradata.

1009

Where do you use proc means over proc freq?

1122

Enterprise data warehouse your projects phase by phase explain?

1922

What exactly do you understand with the term data processing and businesses can trust this approach?

1109

What are the different clients of powercenter?

1062

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

2210

what is informatica metadata?

1038

Write the different types of matrices in microstrategy?

1017

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