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 14734

What is Drill by? drill through?

CMC, iFlex,

1 10720

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13737

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

8 19672

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 10749

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12624

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14409

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 }

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?

1028

What are the various transformation available?

1012

What is the difference between olap and oltp?

1057

What is batch processing?

1032

What are the difference between snow flake and star schema?

1006

How to generate the cubes in framework manager?

1041

What is the difference between Datawarehouse and OLAP?

923

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

978

What is the difference between dependent data warehouse and independent data warehouse?

1007

Whether dimension table can have numeric value?

1149

What is a staging area? Do we need it? What is the purpose of a staging area?

997

Explain the difference between keylokup and joiner?

891

Explain what is data validation strategies for data mart validation after loading process?

1030

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

Difference between e-r modeling and dimentional modeling?

934

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