Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the Difference between DSS & OLTP?

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


Please Help Members By Posting Answers For Below Questions

Why do you use Mapping Parameter and mapping variable?

1743


What do mean by local and global repository?

1201


What are the prerequisite tasks to achieve the session partition?

1231


Why update strategy and union transformations are active?

1030


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2336


What are the differences between joiner transformation and source qualifier transformation?

1148


How to implement security measures using repository manager?

1152


Design a mapping to load a target table with the following values from the above source?

1327


What is lookup transformation?

1023


What is dimensional table?

1054


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1307


How is union transformation utilized?

997


How would you copy the content of one repository to another repository?

995


What is a filter transformation?

1024


What is meant by LDAP users?

1174