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 14733

What is Drill by? drill through?

CMC, iFlex,

1 10719

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13737

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

8 19670

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

Thomson,

2 7625

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

1 5332

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 6561

1.WHAT IS DATA MART ?

HCL,

5 10748

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12624

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14408

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11426

5.Explain ODS ?

HCL,

3 8969

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 13984

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 12709

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5646

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is critical column?

1183

Explain which are the olap tools available that are supported by oracle?

1009

What are the different types of fact tables used in data warehousing?

993

How many types of facts and what are they?

1018

Explain how to generate iqd file from framework manager?

946

in general which algorithms for used?

2026

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

1116

What are cluster analysis in data warehousing?

1108

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

928

In document how to create metrics?

992

Explain the structure of cold fusion?

1043

Can we start and stop single session in concurent bstch?

941

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1225

What are fact, dimension, and measure?

1335

What is the difference between ods and oltp?

1018

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