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.
Write a brief note on a distributed database?
Describe the relationship among entity, entity class, and entity instance.
Write down a short note on the term domain constraints?
Describe briefly the alternative terminology which is employed in the relational model?
Explain how one source columns or the rows may be loaded within the two different tables?
Specify the types of dimensions which are available in the Informatica?
Explain the transformations which are used for the variable port?
What is BCA? Discuss its features?
Differentiate between start schma and Fsldm?
Illustrate the different Types of facts?
18,76,764
1950560 Asked
3,689
Active Tutors
1453668
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!