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
What are the different types of fact tables used in data warehousing?
Explain what is full load & incremental or refresh load?
What is the data type of the surrogate key?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
How to pivot data using informatica when you have variable amount of pivot rows?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain about core dimension,
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what are non-additive facts in detail?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How to improve session performance in aggregator transformation?
Explain the difference between keylokup and joiner?
How are the dimension tables designed?
What are the different types of segments?
Can you state some of the innovations throughout history?