OLAP and OLTP
Explain the following term: a) OLAP b) OLTP
Explain the following term:
a) OLAP
b) OLTP
Expert
OLTP:
In case, an on-line operational database system is utilized for the proficient retrieval and storage and management of the huge amounts of data, then the system is known as on-line transaction processing.
OLAP:
Data warehouse systems serves users (or) knowledge workers within the role of data analysis and decision-making. Such systems may organize and represent the data in several formats. These systems are called as the on-line analytical processing systems.
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
Explain the way to set the number of lines upon a page of output and the width.
How can I partition any table in Sybase? Explain.
Specify various tools in the Business Objects 5.1?
Explain three types of SQL database server architecture?
What are the purposes of using lookups?
Briefly explain the sequence clustering algorithm?
What do you understand by the term denormalization and why would someone consider doing so?
Write a short note on the difference between the disjoint and overlap rule.
Elucidate briefly what is the mapping variables and mapping parameters?
18,76,764
1950906 Asked
3,689
Active Tutors
1439465
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!