Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is Molap and Rolap? What is Diff between Them?

10 17341

what is the use of surrogate key in businessobjects

EDS,

3 8210

How to use the tool Ontobulider

1 3312

what is the difference between DSS and ODS ?

IBM, Satyam,

2 17598

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

Scope International,

2 30617

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

1703

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,

1440

why oracle is the best database for data warehousing?

HCL,

4 7430

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

1666

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

1565

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

1 4037

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

1618

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

1 3848

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

1489

what is parallelism?

2 4161


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain clustering algorithm?

1840


Explain what is batch and describe about types of batches?

596


What is an er diagram?

622


Explain the structure of cold fusion?

575


What is the goal of optimizer?

576






Can we start and stop single session in concurent bstch?

515


What a static and local variable?

578


What is Star Schema?

635


How to generate iqd file from framework manager?

513


What are templates in which way it is help full?

567


Do you view contain data?

546


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

509


What is the purpose of Dataware Control?

590


What are the different types of schemas used in data warehousing?

511


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

617