What Oracle features can be used to optimize my Warehouse
system?
Answer Posted / 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 View All Answers
What are the tools available for etl?
What does level of granularity of a fact table signify?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are modeling tools available in the market?
What are snapshots? What are materialized views & where do we use them?
Fact table is in normalized or de-normalized form?
Explain what is fact less fact table? Where you have used it in your project?
Suggest a good author for hyperion in data warehousing?
Describe the differences between a data warehouse and data mart.
Is union transormation is active transformation?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is a data warehousing?
What are the key columns in Fact and dimension tables?
What is aggregate fact table?
Tell me what is degree of a relation?