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 aggregate table and materialized view?

 596

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

 819

Where the data cube technology is used?

 543

What are data modeling and data mining?

 651

What is surrogate key? Explain with examples.

 605

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

 591

What is a real-time data warehouse?

 585

Can any one explain about core dimension, balanced dimension, and dirty dimension?

 635

How do you define data block size?

 589

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

 564

What are the possible data marts in retail sales?

 538

What is informatica architecture?

 601

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

 547

explain about balanced dimension,

 560

Briefly state different between data ware house & data mart?

 556

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain degenerate dimension table?

537

How to import vsam files from source to target. Do we need a special plugin?

507

Who needs data warehousing?

556

What do you mean by static and local variable?

527

Explain what are data marts?

586




What are the tools available for etl?

544

What is an er diagram?

635

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

553

What are cluster analysis in data warehousing?

559

What is the 4 + 1 view model as it relates to system modeling?

593

I know of using applysimple, but there are other ways too?

563

What are session timeout and application timeout?

526

What is the difference between static cache and dynamic cache?

516

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

515

Explain what are the different methods of loading dimension tables?

505

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