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 Analysis Services?

2058

What are CUBES?

2 10970

What are the primary ways to store data in OLAP?

3 6064

What is META DATA information in Data warehousing projects?

IBM,

2 7344

What is multi-dimensional analysis?

Satyam,

3 5261

What is MDX?

TCS,

2 9098

How did you plan your Data ware house project?

TCS,

2242

What are different deliverables according to phases?

3323

Can you explain how analysis service works?

1 3755

What are the different problems that ?Data mining? can solve?

2774

What are different stages of ?Data mining??

1 6172

What is Discrete and Continuous data in Data mining world?

2575

What is MODEL is Data mining world?

Bank Of America,

2534

How are models actually derived?

1944

What is a Decision Tree Algorithm?

4948

Un-Answered Questions { Data Warehouse }

What are the advantages of raid 1, 1/0, and

908

which type of project we r going to snowflake schema

1931

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2681

What is ods (operation data source)?

952

table actions available in oracle connector?

1557

Why and when do you use proc sql?

1186

Explain what is the main advantage of impromptu over cognos reportnet?

984

Is olap services sold as a separate product?

857

Difference between zabo and webi?

1052

What is surrogate key? Where we use it? Explain with examples.

957

Can you explain surrogate key?

972

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

2011

What’s the use AWS redshift cluster Service?

Define olap designer?

1079

Explain the situation where you have applied SCD in your project?

1976

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