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 |
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is the difference between snowflake and star schema?
What are fundamental stages of data warehousing?
What is the difference between static cache and dynamic cache?
Explain what are the advantages data mining over traditional approaches?
Define Data Warehousing?
Explain about core dimension, balanced dimension, and dirty dimension?
What is staging area?
What is execution plan?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is query panel?
What are the tools available for etl?