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?

959

What are data modeling and data mining?

1085

What is surrogate key? Explain with examples.

1158

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

1061

What is a real-time data warehouse?

998

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

1055

How do you define data block size?

1047

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?

1071

What are the possible data marts in retail sales?

998

What is informatica architecture?

1065

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

959

explain about balanced dimension,

982

Briefly state different between data ware house & data mart?

1049

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

965

Explain batch processing in ab initio?

1458

Un-Answered Questions { Data Warehouse }

How to RD using transformer?

1424

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2126

What is a filter transformation?

1045

What is the use of report studio?

1031

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1699

Explain the various types of filters available.

1006

for what purpose would you use the retain statement? : Sas programming

1096

What is the difference between absolute filtering and standard filtering in microstrategy?

979

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1162

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1215

What is an object prompt?

1026

What is datastage engine?

1179

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2446

What is a node in teradata? Explain

1009

Syntax for case when statement?

1067

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