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

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

Question Posted / g ruban

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

More Data Warehouse General Interview Questions

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

Data WareHousing course in noida

Explain why dimenstion tables are denormalized in nature?

What is VLDB?

What are the different types of join operations?

What are the key features of chameleon that separates it from other algorithms?

What is source qualifier?

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

What is the difference between Datawarehouse and OLAP?

Explain the main difference between inmon and kimball philosophies of data warehousing?

What is operational data store (ods)?

What is hash partition?

For more Data Warehouse General Interview Questions Click Here