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 difference between Business Objects and Hyperion Essbase? Please help me

Cap Gemini, TCS,

1 14815

What is Drill by? drill through?

CMC, iFlex,

1 10802

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13872

What is the "junk dimension"? Give with examples?

8 19890

what is a hot file, why we need in datawarehousing, where we used in general

Thomson,

2 7711

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

1 5419

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 6658

1.WHAT IS DATA MART ?

HCL,

5 10948

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12792

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14692

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11641

5.Explain ODS ?

HCL,

3 9136

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

ACS,

6 14181

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 12854

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5701

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is prompt types of prompts?use of prompts syntax of prompt?

1431

How can you implement many relations in star schema model?

1050

Explain me what is vldb?

982

How to performance tune reports?

1258

Tell me what is degree of a relation?

1056

Explain what is real time data-warehousing?

1168

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2097

How to create context?

1062

Explain the main differences between star and snowflake schema?

1041

Can we take backup when the database is opened?

1095

Explain the importance of data warehouse?

1062

Explain grouped cross tab?

2675

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

1087

What is meta data and system catalog?

2347

What is the difference between agglomerative and divisive hierarchical clustering?

1245

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