What is the Difference between DSS & OLTP?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / guest

5 Answers
11079 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the Difference between DSS & OLTP?..

Answer / topstar

dss(decision support system) consist of past data and
provides analysis of that useful in decision making,where
as oltp(online transaction processing)consist of current
data.

Is This Answer Correct ?

12 Yes

0 No

What is the Difference between DSS & OLTP?..

Answer / pichi

stupid answer it is....:(

Is This Answer Correct ?

8 Yes

2 No

What is the Difference between DSS & OLTP?..

Answer / srinivas

hi friends,
this is right friends , bt oltp is current data. olap
maintains historical data for analyzing purpose.. olap is
read-only data. it is denormized data . it has dimession
table ,fact table data .
it has detailed data

Is This Answer Correct ?

4 Yes

0 No

What is the Difference between DSS & OLTP?..

Answer / srinivas m

Hi Friends This is srinivas m,

DSS -> Decision Support System is Nothing But
OLAP -> Online Analytical Processing System

DSS or OLAP contains Historical Data..Used to make Decisions.. We cannot do any DML operations on datawarehouse.
Those were defined only for Reporting Purpose..

OLTP -> This is nothing but Our Oracle Database.. It contains Volatile Data. it will not maintain any historical data. The OLTP databases contains Current Data Only..

Is This Answer Correct ?

2 Yes

0 No

What is the Difference between DSS & OLTP?..

Answer / shashiall

DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.

Is This Answer Correct ?

2 Yes

10 No

Post New Answer