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

Where the data cube technology is used?

1011

What are data modeling and data mining?

1138

What is surrogate key? Explain with examples.

1244

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1121

What is a real-time data warehouse?

1045

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1121

How do you define data block size?

1107

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1129

What are the possible data marts in retail sales?

1066

What is informatica architecture?

1119

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

1015

explain about balanced dimension,

1047

Briefly state different between data ware house & data mart?

1112

What is an error log table in informatica occurs and how to maintain it in mapping?

1013

Explain batch processing in ab initio?

1501

Un-Answered Questions { Data Warehouse }

Explain two-tier connection?

1003

How to do unit testing in informatica?

1231

Code check-in and check-out commands in AbInitio

4387

explain the function of substr in sas? : Sas-administrator

1070

What do you mean by teradata intellicloud?

1081

How do we call shell scripts from informatica?

1197

Explain teradata utilities?

1101

What is the command in bteq to check for session settings ?

1246

What do you mean by staging area?

1060

How can sas program be validated?

1085

define galaxy repository in informatica

2302

what is stitch query in reportnet?

1158

What is conformed fact?

1161

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2476

What are the benefits of datastage?

1318

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