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

What are the different models used in cluster analysis?

 501

Why facts table is useful in representing the data?

 484

What is the use of dimensional modeling in data warehousing?

 522

What is the function of surrogate key in data warehousing?

 617

Why is chameleon method used in data warehouse?

 677

Why is dimensional normalization not required?

 608

What are the different ways to represent the loading of dimension tables?

 503

What is the difference between data warehouse and operational systems?

 583

What are the stages that are required in data warehousing?

 500

What are the steps involved in designing a fact table?

 480

Describe the differences between a data warehouse and data mart.

 493

Describe a data warehouse.

 534

What is the main difference between star and snowflake star schema? Which one is better and why?

 543

What are situations where snowflake schema is better than star schema when the opposite is true?

 554

What is data cleaning? How can we do that?

 546

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is difference between query studio and report studio?

516

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

503

Which are the olap tools available that are supported by oracle?

509

Is there any default username & pwd for bo designer & supervisor?

561

if you use oracle sql*loader , how do you transform data with it during loading?

1563




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

531

Explain er diagram?

538

Explain what is a cube in data warehousing concept?

540

What are snapshots? What are materialized views & where do we use them?

513

Whether dimension table can have numeric value?

588

What is data type of the surrogate key?

597

How to create different types of templates?

502

Explain what is the extension of file to save template?

503

Can we have multiple application.cfm file in an application?

473

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

524

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