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 43745

What is a Data Warehouse?

9 12500

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

1 4085

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

Apex, ASD Lab, Bank Of America,

15 48802

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

5 11746

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

2 43290

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

Barclays,

1 13347

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

1 4932

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

IBM,

2 8915

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

3 15206

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

Accenture,

6 49858

What is the difference between Oracle Express and Oracle Discoverer?

1 6925

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

3 13242

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

1 5594

Where can one get more info about Data Warehousing?

TCS,

3 10722

Un-Answered Questions { Data Warehouse }

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1074

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2230

What function CATX syntax does?

1224

Why do we need informatica?

994

list and discuss two approaches for updation of target table in Informatica and how they are different.

2111

What is flashback table ? Advance thanks

1942

Differentiate between Load Manager and DTM?

2154

How can sas program be validated?

1038

Can a record be inserted and updated in database using microstartegy?

933

How is MLOAD Client System restarted after execution?

1155

How to create prompts in report net?

989

On which transformations you created partitions in your project?

1349

What is the use of report studio?

1031

How to manage date conversion in Datastage?

1138

Why need staging area database for dwh?

1081

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