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 is the main difference between star and snowflake star schema? Which one is better and why?
How to define a cube??
Explain what is full load & incremental or refresh load?
Explain how to get the first 100 rows from the flat file into the target?
What is called data cleaning?
How to design file watch jobs?
Why is dimensional normalization not required?
What are the advantages of raid 1, 1/0, and
Explain what is metadata reporter?
Explain the hierarchies level data warehousing.
what are different storage options supported by oracle ?
What is loop in data warehousing?
Which columns go to the fact table and which columns go the dimension table?
What are the steps of implementing data warehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
