Answer Posted / 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 |
Post New Answer View All Answers
What is complex mapping?
Which is the t/r that builts only single cache memory?
Slowly changing dimensions, types and where will you use them
explain about unit testing? in real time?
What is the difference between informatics 7x and 8x and what is latest version?
What are the different components of powercenter?
What are the performance considerations when working with aggregator transformation?
Define mapplet?
What is the difference between source qualifier transformations source filter to filter transformation?
What the difference is between a database, a data warehouse and a data mart?
Can you use flat files in Mapplets.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is dynamic cache?
What is the session task and command task?
Design a mapping to load the cumulative sum of salaries of employees into target table?