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
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is core dimension?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain hybrid slowly changing dimension?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain ddl (data definition language)?
What is surrogate key? Where we use it?
What are target types on the server?
Explain er diagram?
Explain the difference between dw and bi?
Store (and count) non-fact records?
What is the data type of the surrogate key?
What are data modeling and data mining?
what are the all possible features supported modify stage?
Describe the differences between a data warehouse and data mart.