What is Drill up/down/by/through
Explain what is meant by the Drill up/down/by/through?
Expert
a) Drill mode enables you to analyze the data from several angles and on the different levels of detail.
b) Drill down exhibits the next level of detail in the hierarchy.
c) Drill up goes back up through the hierarchy in order to display the data over the less detailed levels.
d) By using the Drill through the option you may move to the other hierarchy in order to analyze other data which belongs to the different hierarchy.
e) Drill Through - If lowest level of detail you require is not currently available within the report, you may drill through to the database directly from the drill mode and obtain the data you require. You do not need to edit the query within the Query Panel.
Explain the way to select tables for partition in Sybase?
What do you understand by the term locking in DBMS?
What is the main dissimilarity between horizontal and vertical partitioning?
What is meant by the Data warehouse?
Explain how do I choose which Tables to Partition in the Sybase?
Describe briefly the term data warehouse?
What are some of the demerits related with conventional file processing systems?
Describe briefly reusable transformations?
Why do we utilize a Multidimensional Array within data structure?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
18,76,764
1961271 Asked
3,689
Active Tutors
1420880
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!