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 14744

What is Drill by? drill through?

CMC, iFlex,

1 10726

difference between bo 6.5 and bo xi r2

Accenture, Polaris,

3 13747

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

8 19690

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

Thomson,

2 7631

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

1 5334

How Materialized Views are linked with Oracle DataWare house?

Kirloskar,

1 6570

1.WHAT IS DATA MART ?

HCL,

5 10768

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12640

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14428

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11445

5.Explain ODS ?

HCL,

3 8980

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 13998

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 12721

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 the difference between a primary and secondary actor in use case modeling?

1067

Explain about core dimension, balanced dimension, and dirty dimension?

1012

Explain what is cost benefit analysis (cba)?

978

How to import vsam files from source to target. Do we need a special plugin?

938

What are aggregate transformation?

1043

What is mean by aggregate aware?

1096

What a static and local variable?

1083

What are the fundamental elements of the data warehouse?

1003

What is meant by metadata in context of a data warehouse and how it is important?

1211

Why should we use data ware housing and how can you extract data for analysis with example?

1005

Explain what are the advantages of query studio compared to report studio?

1025

What is the difference between mapping parameter & mapping variable in data warehousing?

993

Explain when do we analyze the tables? How do we do it?

1003

How to export mappings to the production environment?

912

What is the goal of optimizer?

1049

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