What Oracle features can be used to optimize my Warehouse
system?






What Oracle features can be used to optimize my Warehouse system?..

Answer / abhishek soni

Partition table,bitmap index,sequence,table function,sql
loader ,function like cube,roll_up etc.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer




More Data Warehouse General Interview Questions

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

0 Answers  


What are the primary ways to store data in OLAP?

3 Answers  


What is Operational Data Store?

0 Answers   Informatica,


What is DTS ?

1 Answers  


Explain Process flow in data warehouse??

1 Answers   BirlaSoft,






State any 5 of Cods guidelines of an OLAP system, brief description each?

1 Answers  


what is the use of surrogate key in businessobjects

3 Answers   EDS,


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

0 Answers   IBM,


Which kind of index is preferred in DWH?

1 Answers  


How does data mining and data warehousing work together?

2 Answers  


What is mapplet?

1 Answers  


What is a star schema? Why does one design this way?

3 Answers  






Categories