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
How to export mappings to the production environment?
Is union transormation is active transformation?
What is Active Datawarehousing?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain what is analytical or analytic mean?
Describe a data warehouse.
what are the others of "bad files" and "discard files" when using sql*loader?
What is data analysis? Where it will be used?
Explain what is fact less fact table? Where you have used it in your project?
What is scd1 , scd2 , scd3?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
what are relationships?
What is the difference between snowflake and star schema?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
How are the dimension tables designed?
