Discuss the reasons why an organisation may have one or more Online Transaction Processing (OLTP) system but only a single data warehouse.
What will be an ideal response?
An organisation may have several OLTPs due to the range and complexity of the business processes
that support the business. Several OLTP may also be the result of mergers and acquisitions. It is also
possible for an organisation with a single focus to be well supported by a single OLTP. However the
goal for an organisation is to have a single repository of data to support analysis i.e. data warehouse
that offers a single version of the truth.
You might also like to view...
Each time an Access database is opened, the Message Bar displays a security message advising
that certain content has been disabled. Indicate whether the statement is true or false
How can you determine when to use Access or Excel to manage data?
What will be an ideal response?
If the ________ error code displays, you probably mistyped something
A) #ERROR! B) #ENTRY! C) #TYPO! D) #VALUE!
A number that represents a quantity or amount is called a(n) ________
Fill in the blank(s) with correct word