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 20325

what is the use of surrogate key in businessobjects

EDS,

3 9433

How to use the tool Ontobulider

1 4077

what is the difference between DSS and ODS ?

IBM, Satyam,

2 18874

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

Scope International,

2 31589

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

2243

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,

1983

why oracle is the best database for data warehousing?

HCL,

4 9351

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

2129

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

2100

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

1 4746

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

2132

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

1 4560

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

1911

what is parallelism?

2 5187

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

2129

Name a few sectors which use data warehousing?

927

What is data validation strategies for data mart v?

1092

What are the advantages and disadvantages of reporting directly against the database?

982

What is the metadata extension?

1000

What is meta data and system catalog?

2303

What is the goal of optimizer?

1049

Explain what are the possible data marts in retail sales?

1010

What is degenerate dimension table?

1001

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1018

Explain the definition of normalized and denormalized view?

903

What is real-time datawarehousing?

1022

Fact table is in normalized or de-normalized form?

962

What is a real-time data warehouse?

998

What is ods (operation data source)?

997

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