What Oracle features can be used to optimize my Warehouse
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|
if you use oracle sql*loader , how do you transform data with it during loading?
What are the primary ways to store data in OLAP?
What is Operational Data Store?
What is DTS ?
Explain Process flow in data warehouse??
State any 5 of Cods guidelines of an OLAP system, brief description each?
what is the use of surrogate key in businessobjects
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Which kind of index is preferred in DWH?
How does data mining and data warehousing work together?
What is mapplet?
What is a star schema? Why does one design this way?