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?

942

What are level metrics? Why are they needed?

1039

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

1062

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

955

Does microstrategy intelligence server support scheduling?

1047

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

950

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

1059

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

1029

What security is provided with microstrategy desktop?

967

What does microstrategy desktop allow users to do?

904

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

1054

Can I deploy a single bi application in multiple languages?

977

What is the order of precedence of vldb properties?

1006

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

953

What subtotaling features does microstrategy desktop contain?

987

Un-Answered Questions { Data Warehouse }

What is staging area referring to?

1129

How many types of sessions are there in informatica.please explain them?

1166

Explain why we use partitioning the session in informatica?

1092

How would you get two images on microstrategy login page?

989

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4389

In Datastage, how you can fix the truncated data error?

1161

What are tpump utility limitations?

1118

What are the different types of parallelism in ab initio?

1221

Where is teradata rdbms used?

1097

What is the difference between round-robin partitioning and hash partitioning?

973

How online/offline mode impact development and delpoyment?

832

what is metadata? : Sas-bi

1030

What is data type of the surrogate key?

1001

What are the primary keys and foreign keys?

1142

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

1063

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