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...

Difference between DSS & OLTP?

Answer Posted / anil panguluri

OLTP:
1- It is desined to support business transactional processing.
2- It is designed for running the business operations.
3- Volatile data.
4- Current data.
5- Normalised data.
6- Application oriented data.
7- 3-6 months of transaction history.
8- Desinged for clertical operation.

DSS:
1- It is designed to support desition making process.
2- It is designed for analying business operations.
3- Non volatile database.
4- Detailed data.
5- denormalised data.
6- Subject oriented data.
7- 5-20 years of transaction data.
8- Desinged for manageral access.
6-

Is This Answer Correct ?    34 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is many-to-many dimensional model in datawarehousing ?

930


Why should we use data ware housing and how can you extract data for analysis with example?

994


Explain the difference between data ware house & data mart?

945


What are the advantages of cold fusion?

948


What are data modeling and data mining?

1081


Explain what are the possible data marts in retail sales?

1007


Explain what is the difference between datawarehouse and bi?

963


Difference between cold fusion 5 and cold fusion mx 6?

992


Explain what does level of granularity of a fact table signify?

956


What are the advantages and disadvantages of reporting directly against the database?

976


What function should we use to display the value entered or selected by a user in response to a prompt?

988


What is a full backup?

954


Explain what are the basic needs to join two sources in a source qualifier?

1137


Explain the data type of the surrogate key?

948


Explain ddl (data definition language)?

1006