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 your spectra photometer working principles?
Explain what is fact less fact table? Where you have used it in your project?
What we will do with the universe for faster process?
How can we run the graph? What is the procedure for that?
What is difference between query studio and report studio?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
explain about balanced dimension,
What are the types of partitioning?
How to drill through from a powerplay cube to reportnet?
Explain what is a view as it relates to system modeling?
What is called dimensional modelling?
What is Cognos script editor?
What is the difference between filter and lookup transformation?
What is fact less fact table? Where you have used it in your project?
what type of raid setup would you put your tx logs?