What are the advantages and disadvantages of reporting directly against the database?
- 1 Answers
- 1063 Views
- I also Faced
- E-Mail Answers
Answer / Ruchi Porwal
Advantages:
1. Immediate access to fresh data without needing to refresh reports.
2. Faster processing as there is no intermediate step between the database and the report.
3. Reduced storage requirements for pre-generated reports.nnDisadvantages:
1. Increased complexity due to SQL knowledge requirement.
2. Lack of user-friendly formatting options.
3. Risk of affecting other processes or users due to improperly written queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the difference between filter and conditin?
What is an OLAP (On-line Analytical processing) system?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Where do we use semi and non additive facts?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
How can we do data cleaning?
What is subject area?
What is vldb(very large databases)?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is operational data store (ods)?
what is table partitioning? How it is useful to warehouse database?
What does level of granularity of a fact table signify?
Teradata 
