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
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what are the different types of data warehousing?
What is the difference between metadata and data dictionary?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is the definition of cube in datawarehousing?
What are data modeling and data mining?
What is your spectra photometer working principles?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is surrogate key? Where we use it?
What is a cube in data warehousing concept?
What are fact, dimension, and measure?
What are the mapping paramaters and maping variables?
Where the cache files stored?
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?
what are the major three types of modeling used?