Answer Posted / sdfs
Characteristic Operational Support System Decision Support System
Data Currency Current operations Real-time data Historic data,Snapshot,of company data Timecomponent(week/month/year)
Granularity Atomic detailed data Summarized data
Summarization level Low: some aggregate yields High: many aggregation levels
Data model Highly normalized mostly relationl DBMS Nonnormalized Complex structures Some relational, but mostly multidimensional DBMS
Transaction type Mostly updates Mostly query
Transaction volumes High update volumes Periodic loads and summary calculations
Transaction speed Updates are critical Retrievals are critical
Query activity Low to medium High
Query scope Narrow range Broad range
Query complexity Simple to medium Very complex
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between junk dimension and degenerated dimension?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is the limit to the number of sources and targets you can have in a mapping?
What is meant by metadata in context of a data warehouse and how it is important?
Explain functional dependency?
Explain what is a three tier data warehouse?
What is data analysis? Where it will be used?
What are cluster analysis in data warehousing?
What are the differences between star and snowflake schema?
What is the purpose of Dataware Control?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what is ods (operation data source)?
What is meant by metadata in context of a data warehouse?
What are data modeling and data mining?
Explain multivalued dependency?