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

Explain me what are conformed dimensions?

1097

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

1020

What is fact less fact table? Where you have used it in your project?

1080

What is pre-emptive and non-pre-emptive?

1028

Explain what does level of granularity of a fact table signify?

1001

What is ods (operation data source)?

1060

What is data validation strategies for data mart v?

1172

Explain what are fact, dimension, and measure?

1047

Explain why denormalization is promoted in universe designing?

1001

What is latest version of power center / power mart?

1143

What is partitioning? What are the types of partitioning?

1232

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

971

What is an er diagram?

1102

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

967

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1076

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2379

How to performance tune reports?

1259

can anybody mail me the FAQS for hyperion essbase amd planning

5702

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

967

what is difference between drill & scope of analysis?

1169

In microstrategy, how can we direct the sql generated to use a specifc table?

1091

What should I have in mind when building olap solution from scratch?

1057

Can you brief about the Data warehouse project you worked on?

2439

How did you plan your Data ware house project?

2364

Where we use surrogate key explain with example?

1206

Explain what is the limit to the number of sources and targets you can have in a mapping?

1057

What is factless fact tables?

1289

What are session timeout and application timeout? Where we have to do this process?

1086

What is the difference between power center and power mart?

1081

What is drilling across?

1046

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