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 14606

What is Drill by? drill through?

CMC, iFlex,

1 10622

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13577

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

8 19358

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

Thomson,

2 7496

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

1 5245

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 6457

1.WHAT IS DATA MART ?

HCL,

5 10477

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12456

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14065

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11182

5.Explain ODS ?

HCL,

3 8794

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 13736

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 12541

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5574

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the difference between snow flake and star schema?

945

What is ods (operation data source)?

952

What are necessary tasks to install reportnet software?

858

How can we run the graph? How can we schedule the graph in unix?

886

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2211

What is the difference between aggregate table and materialized view?

1031

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

966

How to drill through from a powerplay cube to reportnet?

875

Explain the difference between oltp and olap?

1058

What are the different methods of loading dimension tables?

944

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

977

Explain what is partitioning? What are the types of partitioning?

905

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1908

What is degenerate dimension table?

947

Explain difference between snow flake and star schema.

964

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