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 types of dimension tables

Infotech,

19 44301

What is a Data Warehouse?

9 12765

What is a ETL/ How does Oracle support the ETL process?

1 4178

What is the difference between a data warehouse and a data mart?

Apex, ASD Lab, Bank Of America,

15 49314

What is the difference between a W/H and an OLTP application?

5 11927

What is the difference between OLAP, ROLAP, MOLAP and HOLAP?

2 43418

What is the difference between an ODS and a W/H?

Barclays,

1 13447

What Oracle tools can be used to design and build a W/H?

1 4995

When should one use an MD-database (multi-dimensional database) and not a relational one?

IBM,

2 9048

What is a star schema? Why does one design this way?

3 15380

When should you use a STAR and when a SNOW-FLAKE schema?

Accenture,

6 50065

What is the difference between Oracle Express and Oracle Discoverer?

1 7001

How can Oracle Materialized Views be used to speed up data warehouse queries?

3 13434

What Oracle features can be used to optimize my Warehouse system?

1 5673

Where can one get more info about Data Warehousing?

TCS,

3 10871

Un-Answered Questions { Data Warehouse }

List out some of the air commands used in abintio?

1434

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

969

Explain how we drill up week to month?

1143

what is the difference between == and eq in UNIX shell scripting?

1565

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1199

Explain datawarehousing?

1122

What do you understand by term role-playing dimension?

1123

How do you define data block size?

1101

How can we create a dynamic column name in cognos?

1008

how many maximum session supports to multiload in teradata ??

2177

How do you add default rules in transformer?

1274

What is the use of an aggregator cache file?

1252

Briefly describe lookup transformation?

1099

What is a standalone command task?

1259

Explain multivalued dependency?

1048

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