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


Please Help Members By Posting Answers For Below Questions

What are necessary tasks to install reportnet software?

691


What is a real-time data warehouse? How is it different from near to real-time data warehouse?

733


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

709


Why fact table is in a normal form?

722


How can we acheive correlated sub-query in designer?can anyone help me in this regard?

648


What is prompt types of prompts?use of prompts syntax of prompt?

871


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

710


List down some of the real time data-warehousing tools?

737


How can you set the client management?

749


What are the various transformation available?

749


What are data modeling and data mining?

830


Explain some of modeling tools available in the market?

702


What does level of granularity of a fact table signify?

831


What is informatica architecture?

810


How to improve session performance in aggregator transformation?

726