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 are the vldb properties? Which level of vldb configurations have the highest precedence?

995

What are level metrics? Why are they needed?

1092

How does microstrategy object manager determine if two objects in different projects are the same?

1141

At which levels you can set the vldb properties? Which level has the highest pecedence?

992

Does microstrategy intelligence server support scheduling?

1084

What leads to a cross-join or how does a cross-join occur?

994

How can you make the sql query to be based on a specific table of your choice?

1104

To save time, can many reports be run at the same time?

1097

What security is provided with microstrategy desktop?

1017

What does microstrategy desktop allow users to do?

948

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1099

Can I deploy a single bi application in multiple languages?

1030

What is the order of precedence of vldb properties?

1072

What specific features and functionality do I get with olap services?

1017

What subtotaling features does microstrategy desktop contain?

1051

Un-Answered Questions { Data Warehouse }

What is program data vector (pdv) and what are its functions?

1321

What are attribute roles?

1030

What is job control?

1203

What is meant by Reportstudio shortcut?

2226

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

When do we analyze the tables?

1022

What is PDV?

1209

What is Metrics designer?

1085

What are the types of studio present in Cognos?

1081

Can you define a query subject?

1065

What is a level of granularity of a fact table?

1223

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

1003

what is the difference between nodup and nodupkey options? : Sas programming

1273

What are the approaches used by optimizer during execution plan?

969

Explain what are the various methods of getting incremental records or delta records from the source systems?

1032

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