1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

 2 41989

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

Barclays,

1 12434

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

 1 4266

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

IBM,

2 7713

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

 3 13868

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

Accenture,

6 47606

What is the difference between Oracle Express and Oracle Discoverer?

 1 6220

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

 3 11761

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

 1 4905

Where can one get more info about Data Warehousing?

TCS,

3 9339

what is the difference between aggregate table and fact table ? how do you load these two tables ?

Target,

12 49543

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

Oracle,

3 8733

how can one connect two fact tables ? is it possible ? how?

ABC, Oracle, Patni,

8 34664

Difference between ODS and Staging

HeadStrong, TCS,

4 38589

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 48777

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Where the data cube technology is used?

539

What is data type of the surrogate key?

597

What are the different types of schemas used in data warehousing?

504

Explain what is power center repository?

550

Could any one explain me how to create cascading prompts?

491




What are diagrams?

611

What are the types of dimensional modeling?

597

What is aggregate fact table?

516

Briefly state different between data ware house & data mart?

545

Why is business intelligence (bi) important in data warehousing?

520

in general which algorithms for used?

1539

Explain what is the difference between olap and datawarehosue?

588

Can we start and stop single session in concurent bstch?

512

Describe the differences between a data warehouse and data mart.

493

What is the main difference between schema in rdbms and schemas in datawarehouse?

530

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