What is enterprise warehouse
Explain what is meant by the term enterprise warehouse?
Expert
An enterprise warehouse collects all the information’s regarding the subjects spanning the entire organization. It offers the corporate-wide data integration, typically from one (or) more operational systems (or) the external information providers. It consists of the detailed data as well as the summarized data and may range in size from the few giga-bytes to the hundreds of giga bytes, tera-bytes (or) beyond.
Illustrates the term data sparsity and how this effect upon aggregation?
Explain the term Enterprise and Workgroup modes?
Explain metrics folders in brief?
Give a brief introduction of the term Dimensional Modeling?
What is meant by the Surrogate key?
Write down a short note on XML and also describe the uses of it?
Explain the way to support Row Level Locking in Sybase.
Describe the main characteristic of the database administrator?
Explain how do I choose which Tables to Partition in the Sybase?
Name four applications which are employing for triggers in DBMS?
18,76,764
1945980 Asked
3,689
Active Tutors
1425745
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!