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?

1100

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

1385

Where the data cube technology is used?

959

What are data modeling and data mining?

1085

What is surrogate key? Explain with examples.

1158

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

1061

What is a real-time data warehouse?

998

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

1055

How do you define data block size?

1047

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?

1070

What are the possible data marts in retail sales?

996

What is informatica architecture?

1065

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

959

explain about balanced dimension,

980

Briefly state different between data ware house & data mart?

1049

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2238

What is "method/1"?

1060

How many types of facts and what are they?

1018

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2138

How to load the time dimension?

1008

Can you state some of the innovations throughout history?

981

Explain difference between e-r modeling and dimentional modeling?

985

Explain which columns go to the fact table and which columns go the dimension table?

928

What are Non-additive facts?

1169

What is load manager?

1045

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

1102

Explain functional dependency?

1087

What are fact, dimension, and measure?

1335

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1009

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

1043

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