Partition table,bitmap index,sequence,table function,sql loader ,function

What Oracle features can be used to optimize my Warehouse
system?

Question Posted / abhishek soni

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

Please Help Members By Posting Answers For Below Questions

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2208

Explain what are the different types of data warehousing?

914

What is the difference between metadata and data dictionary?

1061

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

952

What is the definition of cube in datawarehousing?

934

What are data modeling and data mining?

1033

What is your spectra photometer working principles?

933

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

849

What is surrogate key? Where we use it?

932

What is a cube in data warehousing concept?

1016

What are fact, dimension, and measure?

1248

What are the mapping paramaters and maping variables?

977

Where the cache files stored?

954

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

899

what are the major three types of modeling used?

1018