Analysis Services Interview Question:

What is difference in DSS and OLTP?

Submitted by: Administrator

The DSS is (Decision Support System) used for the decision making purposes, not for day-2 day issues.by the top level/ sr/middle level managments people in a established company.

but the OLTP SYSTEMS handles the day-day transactions, data entries, billing etc issues .

The DSS WILL be handled by only a few users , especially

top poeple in the corporate ladder hence The number of users who are making use of DSS are less.

but in OLTP(ONLINE TRANSACTION PROCESSING) the number of the users are high, since no such kind of decision making is entailed.
Submitted by: Administrator