What Oracle features can be used to optimize my Warehouse
system?
Answer / 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 |
How to add a number to a macro variable?
What are the stages that are required in data warehousing?
List down some of the real time data-warehousing tools?
What are the different models used in cluster analysis?
What are aggregate transformation?
What is degenerate dimension table?
How to pivot data using informatica when you have variable amount of pivot rows?
What is partitioning? What are the types of partitioning?
What are the different methods of loading dimension tables?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What are data validation strategies for data mart validation after loading process?