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
What is many-to-many dimensional model in datawarehousing ?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain the difference between data ware house & data mart?
What are the advantages of cold fusion?
What are data modeling and data mining?
Explain what are the possible data marts in retail sales?
Explain what is the difference between datawarehouse and bi?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what does level of granularity of a fact table signify?
What are the advantages and disadvantages of reporting directly against the database?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is a full backup?
Explain what are the basic needs to join two sources in a source qualifier?
Explain the data type of the surrogate key?
Explain ddl (data definition language)?