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?

907

What are level metrics? Why are they needed?

1004

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

1004

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

917

Does microstrategy intelligence server support scheduling?

1002

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

919

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

1022

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

1000

What security is provided with microstrategy desktop?

935

What does microstrategy desktop allow users to do?

876

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

1015

Can I deploy a single bi application in multiple languages?

936

What is the order of precedence of vldb properties?

964

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

911

What subtotaling features does microstrategy desktop contain?

955

Un-Answered Questions { Data Warehouse }

What is non-aggregate metric?

967

What is the difference between %put and symbolgen? : sas-macro

1194

What is enterprise data warehousing?

1002

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1131

Who needs data warehousing?

1020

what do you mean by data staging area? : Sas-di

1092

What is a sequence generator transformation?

987

Mention a few of the ETL tools that come under Teradata.

1043

What is meant by target load plan?

933

Describe in detail about lookup?

1046

If money were no object, what would you like to do?

3157

Enlist various types of routines in datastage.

1204

what is sas database server? : Sas-di

1082

Differentiate between hash file and sequential file?

1025

What are the key elements of a data processing system?

1171

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