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 is the difference between data warehouse and operational systems?
What are components of reportnet?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is bi?
Explain clustering algorithm?
can anybody mail me the FAQS for hyperion essbase amd planning
Why is chameleon method used in data warehouse?
Define Data Warehousing?
What are fundamental stages of data warehousing?
Explain how to get the first 100 rows from the flat file into the target?
What are the steps involved in designing a fact table?
What is loop in data warehousing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Start a batches with in a batch?