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 necessary tasks to install reportnet software?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Why fact table is in a normal form?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is prompt types of prompts?use of prompts syntax of prompt?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
List down some of the real time data-warehousing tools?
How can you set the client management?
What are the various transformation available?
What are data modeling and data mining?
Explain some of modeling tools available in the market?
What does level of granularity of a fact table signify?
What is informatica architecture?
How to improve session performance in aggregator transformation?