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 Molap and Rolap? What is Diff between Them?

10 20592

what is the use of surrogate key in businessobjects

EDS,

3 9566

How to use the tool Ontobulider

1 4148

what is the difference between DSS and ODS ?

IBM, Satyam,

2 18987

Explain about Control M JObs detaily?How to execute this.

Scope International,

2 31701

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2302

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

SingleTusk,

2041

why oracle is the best database for data warehousing?

HCL,

4 9534

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2186

if you use oracle sql*loader , how do you transform data with it during loading?

2144

three ways sql*loader could load data, what are those three types?

1 4809

what are the others of "bad files" and "discard files" when using sql*loader?

2180

how do you use commit frequencies? how does it affect loading performance?

1 4641

what are the other factors of the database on which the loading performance depend?

1957

what is parallelism?

2 5305

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is Active Datawarehousing?

1057

Explain what are conformed dimensions?

1145

What is type 2 version dimension?

1019

What is loop in data warehousing?

1200

What are the possible data marts in retail sales?

1060

Explain why are oltp database designs not generally a good idea for a data warehouse?

1079

What is the difference between metadata and data dictionary?

1218

What is critical column?

1259

How to create context?

1062

Explain the difference between filter and conditin?

1014

What is the difference between star and snowflake schemas?

1317

What is perform recovery?

1192

Can any one explain the hierarchies level data warehousing.

1042

Explain the versions of reportnet?

1042

What are the various file formats involved in reportnet?

1026

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