What Oracle tools can be used to design and build a W/H?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain when do we analyze the tables? How do we do it?
Explain reference cursor?
What is critical column?
What Oracle features can be used to optimize my Warehouse system?
capital of tamilnadu
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Can you explain how analysis service works?
Tell me one example for junk dimension?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Name a few sectors which use data warehousing?
What are the different types of schemas used in data warehousing?