Answer Posted / igor grubisic
These are two different entities. While OLTP is a type of
data base organisation, DSS is a mathematical methodology.
OLTP contains transactional data and in contrast to it,
historycal data are contained in OLAP i.e. data
warehousing. In contrast to that, DSS can benefit from both
OLAP and OLTP. The main strength of DSS is a possibility to
use subjective reasoning of decision maker, in order to
make a decision. As a data foundation for DSS one can
utilize OLAP, OLTP or just its own logic and experience.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are Non-additive facts?
Why should you put your data warehouse on a different system than your oltp system?
Explain the data type of the surrogate key?
What is data analysis?
What are diagrams?
What is dimensional modelling?
Define Data Warehousing?
How to pivot row data using informatica?
Explain what are slowly changing dimensions?
What are the tools available for etl?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are the different types of fact tables used in data warehousing?
What are necessary tasks to install reportnet software?
Explain what is the difference between powerplay transformer and power play reports?