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 parallel query?

2132

what are different ways of loading data to data warehouse using oracle?

1 5445

what is table partitioning? How it is useful to warehouse database?

EDS, IBM,

1 8625

what are different types of partitioning in oracle ?

3 11663

what is indexing ? what are different types of indexes supported by oracle ?

2 10878

what are different storage options supported by oracle ?

2136

what is query optimizer? what are different types of optimizer s supported by oracle ?

ABC,

1 13329

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

IBM, Ness Technologies,

3 16613

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

iFlex, Wipro,

1 5522

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2177

How do you setup Lo-cockpit?

3241

difference between For each and for all

2 9559

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Accenture, IBM, TCS,

6 11783

Tell me one example for multi valued dimension or bridge table?

Accenture, CMC, IBM, Logica CMG, TCS,

2 19117

Tell me one example for junk dimension?

TCS,

9 45912

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is loop in data warehousing?

1200

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

948

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

1008

What are the steps involved in designing a fact table?

934

What are the different types of segments?

1035

Explain what are the different methods of loading dimension tables?

995

What are the advantages of raid 1, 1/0, and

1022

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1245

Describe the differences between a data warehouse and data mart.

1065

Explain what is the difference between view filter and report filter?

1035

What are the other names given to data warehousing?

1152

Code the tables statement to produce a multi-level frequency?

1046

Briefly state different between data ware house & data mart?

1085

What is index awareness in universe?

1088

What is the difference between constraind base load ordering and target load plan?

1157

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