Interested to Buy Any Domain ? << Click Here >> for more details...
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 data cleaning? How can we do that?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is the difference between power center & power mart?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is a data profile?
Explain how are the dimension tables designed?
Explain what is the difference between power center & power mart?
What are the stages that are required in data warehousing?
What is loop in data warehousing?
What are the design methods of data warehousing?
How to define a cube??
What are the types of dimensional modeling?
How to test report in reportnet?
Explain where do we use semi and non additive facts?
