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 13816

What is Drill by? drill through?

CMC, iFlex,

1 9645

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 12475

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

8 17309

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

Thomson,

2 6489

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

1 4592

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 5642

1.WHAT IS DATA MART ?

HCL,

5 9155

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 10969

3.What is fact less fact ?

Accenture, HCL, TCS,

9 11643

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 9426

5.Explain ODS ?

HCL,

3 7486

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 12118

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 11309

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5183


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to test report in reportnet?

555


What is loop in data warehousing?

669


Which component has onread method and what it is used for?

498


Why null values are mapped as 0 in fact tables?

524


What is the advantages data mining over traditional approaches?

513






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?

487


What we will do with the universe for faster process?

557


How to drill through from a powerplay cube to reportnet?

494


Explain can report net connect multiple datasource at a time in report creation time?

481


What is normalization, first normal form, second normal form, third normal form?

525


Explain dimension table ?

549


What are steps we have to follow in designing the userfriendly universe?

539


What is the extension of file to save template?

565


Tell me what is degree of a relation?

516


Explain what is ods (operation data source)?

532