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?

 600

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

 821

Where the data cube technology is used?

 550

What are data modeling and data mining?

 659

What is surrogate key? Explain with examples.

 610

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

 597

What is a real-time data warehouse?

 591

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

 640

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?

 570

What are the possible data marts in retail sales?

 539

What is informatica architecture?

 612

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

 556

explain about balanced dimension,

 565

Briefly state different between data ware house & data mart?

 566

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

603

Explain what is metadata reporter?

573

What is the difference between constraind base load ordering and target load plan?

650

What is crass reference table?

596

What are different deliverables according to phases?

2857




How can we determine what records to extract?

599

Explain me what are data marts?

598

How can we run the graph?

584

What are the different models used in cluster analysis?

519

Explain the difference between filter and conditin?

566

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

534

How can we schedule the graph in unix?

564

What is Cognos script editor?

2076

Compare cold fusion with other programming languages?

561

Explain conformed fact?

527

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