Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What is the difference between aggregate table and materialized view?

1055

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

1332

Where the data cube technology is used?

925

What are data modeling and data mining?

1044

What is surrogate key? Explain with examples.

1086

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

1027

What is a real-time data warehouse?

964

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

1024

How do you define data block size?

1001

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?

1034

What are the possible data marts in retail sales?

953

What is informatica architecture?

1025

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

914

explain about balanced dimension,

938

Briefly state different between data ware house & data mart?

1019

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is load manager?

1002

What is the function of surrogate key in data warehousing?

1019

Is union transormation is active transformation?

933

Explain Association algorithm in Data mining?

2274

How we are using this function?

1070

How can we do data cleaning?

1006

What is critical column?

1128

What is the difference between drill through and masterdetail reports?

1091

what are different storage options supported by oracle ?

2054

What is a view as it relates to system modeling?

946

Where the cache files stored?

976

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

941

Explain datawarehousing?

1015

What is the advantages data mining over traditional approaches?

928

Why we use repository connectivity?

945

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