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 |
What is a Data Cube?
What is the use of incremental aggregation? Explain me in brief with an example?
Explain what is metadata reporter?
What is incremintal loading?
Name a few sectors which use data warehousing?
Can any one explain the hierarchies level data warehousing.
Explain difference between data ware house & data mart?
Difference between DSS & OLTP?
What is a relationship?
What is a core dimension?
What is query panel?
Tell me the Top 10 features of oracle that supports datawarehousing.