Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between DSS & OLTP?
- 5 Answers
- 12722 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / shashiall
DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.
| Is This Answer Correct ? | 2 Yes | 10 No |
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
what is hash table in informatica?
HOW TO GET THE LATEST DATA IN SCD ?
How many types of sessions are there in informatica.please explain them?
what is unit testing?tell me proceedure
What is the difference between IN and Exists in Oracle?
Clarify the aggregator change?
What is a unit Testing?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What is confirmed dimension with scenario
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
Teradata 
