Interested to Buy Any Domain ? << Click Here >> for more details...
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
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What according to you might be the future of data warehousing?
How many types of facts and what are they?
Can we take backup when the database is opened?
What are the different methods of loading dimension tables?
What is load manager?
What is a hash cluster?
How many project sources we can create in metadata?
Explain grouped cross tab?
What are necessary tasks to install reportnet software?
Explain me what are data marts?
What is Cognos script editor?
Explain how to get the first 100 rows from the flat file into the target?
What are the stages of datawarehousing?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
