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 |
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,
What is factless fact tables?
What is operational data store (ods)?
Explain what are fact, dimension, and measure?
Explain swot analysis?
What is meant by metadata in context of a data warehouse?
what is the use of surrogate key in businessobjects
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What a static and local variable?
What is the difference between connected and unconnected stored procedures?
Explain what is partitioning? What are the types of partitioning?
What is recovering sessions?