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 key features of chameleon that separates it from other algorithms?

1184

What are the different types of schemas used in data warehousing?

993

What is the function of etl when used in data warehousing?

1005

What is the purpose of cluster analysis in data warehousing?

1053

Why is business intelligence (bi) important in data warehousing?

993

What are the different types of fact tables used in data warehousing?

1047

What are the different types of scd's used in data warehousing?

1295

What are the different models used in cluster analysis?

1011

Why facts table is useful in representing the data?

1055

What is the use of dimensional modeling in data warehousing?

1056

What is the function of surrogate key in data warehousing?

1141

Why is chameleon method used in data warehouse?

1227

Why is dimensional normalization not required?

1146

What are the different ways to represent the loading of dimension tables?

984

What is the difference between data warehouse and operational systems?

1190

Un-Answered Questions { Data Warehouse }

What does de-partition mean in abinitio?

1335

What is latest version of power center / power mart?

1151

Define meta stage?

1262

Performance tuning( what you did in performance tuning)

2059

Your application mode has crashed. How would you run your i-server?

1051

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2240

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

1038

What is the difference between dependent data warehouse and independent data warehouse?

1058

What is meant by a Clique?

1118

What is the roundrobin collector?

1152

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1285

what is degenerate key in oracle ?whare do we use it?

2618

How would you find out whether a sql query is using the indices you expect?

1120

How many dimensions are there in informatica?

1139

What does proc print, and proc contents are used for?

1229

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