Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

10 17274

what is the use of surrogate key in businessobjects

EDS,

3 8180

How to use the tool Ontobulider

1 3292

what is the difference between DSS and ODS ?

IBM, Satyam,

2 17568

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

Scope International,

2 30580

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

1687

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,

1431

why oracle is the best database for data warehousing?

HCL,

4 7393

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

1658

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

1552

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

1 4025

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

1605

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

1 3826

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

1481

what is parallelism?

2 4140


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

523


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

531


Database in use is oracle?

578


Where the data cube technology is used?

524


Explain what is the difference between datawarehouse and bi?

500






Explain the difference between data ware house & data mart?

535


How do you create surrogate key using ab initio?

525


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

510


What are the various transformation available?

544


What is the use of tabular model, tabular sql, tabular reference in real time application?

501


How to define a cube??

527


Can you state some of the innovations throughout history?

524


What are data validation strategies for data mart validation after loading process?

500


Explain what is a view as it relates to system modeling?

547


How can we do data cleaning?

563