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

Explain bus schema?

981

Explain what are the possible data marts in retail sales?

1014

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

986

Explain differences between star and snowflake schemas?

1163

Explain vldb?

1038

What is incremintal loading?

1116

Explain hybrid slowly changing dimension?

1011

What is top business?

1074

Explain what are the steps to do to use alerts in bo?

1078

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

988

Explain what is the difference between slice and dice and cross tab report?

1081

Explain how to execute the plsql procedure from the report by clicking with mouse?

1053

Explain how to schedule the report in b.o?

1053

Explain the difference between detect alias and detect context?

1109

Explain difference between zabo and webi?

1104

Un-Answered Questions { Data Warehouse }

What is staging area referring to?

1133

Whether dimension table can have numeric value?

1159

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1022

State the differences between sql override and lookup override?

1215

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1083

How many dimensions are there in informatica?

1096

Quickly characterize reusable change?

1126

What is the difference between informatics 7x and 8x and what is latest version?

1087

How to create diff. Types of templates?

1053

Explain informatica architecture?

1005

What are the default statistics for means procedure?

1253

What is the purpose of upsert command?

1180

Explain what is partitioning? What are the types of partitioning?

973

Clarify the aggregator change?

1034

What is a sequence generator transformation?

1025

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