Describe the term a Cube and Linked Cube
Briefly describe the term a Cube and Linked Cube with reference to data warehouse?
Expert
A data cube keeps data in a summarized description which assists in a quicker analysis of data. Whereas linked cubes employ the data cube and are stored on any other analysis server. Linking various data cubes decreases the possibility of sparse data.
Illustration: a data cube might store the Employee presentation. But so as to identify the hours that computed this presentation, one can make another cube through linking it to the root cube (or in this case employee performance).
Explain the Aggregate Awareness?
Define the way of passing of variables to a SQL routine.
What do you understand by the term RFM analysis?
Illustrate in brief some of the products of the Sybase?
What is OLAP? Briefly define it.
Describe briefly perform recovery?
What do you understand by the term denormalization and why would someone consider doing so?
Illustrate the term data mart. What do you mean by it?
Explain the package folders?
How can I partition any table in Sybase? Explain.
18,76,764
1949928 Asked
3,689
Active Tutors
1459674
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!