difference between OLTP and OLAP
State the difference between OLTP and OLAP?
Expert
OLTP is defined as Online Transaction Processing which consists of the normalised tables. However, OLAP or Online Analytical Programming consists of the history of OLTP data that is non-volatile acts as Decisions Support System.
What is meant by the Cardinality?What is meant by the Cardinality?
Briefly describe the term Object qualification?
What is a derived (artificial) primary key? When must this be used?
What are some of the demerits related with conventional file processing systems?
State the benefits of the Business Objects over the other DSS?
Explain the way of establishing connection by ODBC.
Why use references quite than pointers within the public API, mainly for arguments that are modified?
States the term SnowFlake.
Clarify briefly why dimension tables is de-normalized in the nature?
Specify the different Multidimensional analysis methods which are available in the Business Objects?
18,76,764
1955962 Asked
3,689
Active Tutors
1433511
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!