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.
Illustrates the term data structure?
partial specialization and total specialization rules in enhanced erd.......
Illustrate the different Types of facts?
Mini-Case The Hatcher Company is in the process of developing a new inventory management system. One of the event handling processes in that system is Receive Supplier Shipments. The (inexperienced) systems analyst on the project has spent time in the warehouse observing this process and develo
Describe briefly Aggregate transformation?
Specify different types of transformations available in the Informatica?
Write out the disadvantages of using the Alias?
What is meant by the snow flake schema?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Explain the way to shrink a Database?
18,76,764
1957258 Asked
3,689
Active Tutors
1413621
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!