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
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is metadata in context of a datawarehouse and how it is important?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain what is analytical or analytic mean?
What are cluster analysis in data warehousing?
What are loops in Datawarehousing?
what is user variable in affinium campaign? and some real time examples.
What is defined as partial backup?
Explain what are the advantages of query studio compared to report studio?
What is a linked cube?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How to pivot row data using informatica?
How to generate the cubes in framework manager?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
