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
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain swot analysis?
What is dimensional modelling?
What is edw?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain what is difference between query studio and report studio?
What is the very basic difference between data warehouse and operational databases?
Explain the main differences between star and snowflake schema?
Where the data cube technology is used?
Explain vldb?
List any five applications of data warehouse.
Explain how are the dimension tables designed?
What is the purpose of cluster analysis in data warehousing?
explain about balanced dimension,
Explain what are components of reportnet?