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 index awareness in universe?

1039

What is data stream and data adaopter?

1098

What are the advantages of cold fusion?

957

How can you set the session management?

1132

I need to set predefined condition. How I do this?

1023

What are steps we have to follow in designing the userfriendly universe?

981

Difference between cold fusion mx 6 and cold fusion mx 7?

845

How can you set the client management?

1025

Explain in detail abt measure objects? And what is the use of it? How to create it?

1021

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1051

What is mean by aggregate aware?

1099

How to create context?

1018

What are universe requirements?

1059

How to performance tune reports?

1185

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

911

Un-Answered Questions { Data Warehouse }

What is the difference between a scan component and a rollup component?

1198

Explain is there any other repository domains rather than universe, security, document?

1104

What is the main difference between inmon and kimball philosophies of data warehousing?

1125

what do you mean by kimball?

1008

What can you learn from the SAS log when debugging?

1397

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

911

Do we need an ETL tool? When do we go for the tools in the market?

976

i was asked what are the caluclations done by you in your report? plz give reply

2198

What do you understand by the term 'aggregate advisor?'

972

How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?

3968

Differentiate between reusable transformation and mapplet.

1107

What are the popular informatica products?

1019

Is there any default username & pwd for bo designer & supervisor?

1036

What are cognos connection initial page components?

1149

What are the different methods ot loading a dimension table? A fact table etc?

1049

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