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

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

0 Answers  


Explain Process flow in data warehouse??

1 Answers   BirlaSoft,


Disply the dname wise maximum salary

9 Answers   Principal Finance,


What is data validation strategies for data mart v?

0 Answers  


How to calculate fact table granularity?

0 Answers  


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

0 Answers  


How to create different types of templates?

0 Answers  


What is META DATA information in Data warehousing projects?

2 Answers   IBM,


What is surrogate key? Where we use it explain with example?

0 Answers  


Explain grouped cross tab?

0 Answers  


What is BCP?

1 Answers  


What is data analysis?

0 Answers  


Categories