What are the advantages and disadvantages of reporting directly against the database? Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement)

Questions by DrunkenMaster

Showing Answers 1 - 1 of 1 Answers

shani

  • May 31st, 2006
 

There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.

Adv of reporting directly against the database(OLTP): No need to sepertaley maintain a Database for it.(Space consumption is recduced).

Disadv of reporting directly against the database(OLTP): It slows down the process bcoz OLTP system is designed for the online application but a DataWarehouse application which requires to do analysis and hence takes the same data but takes a long time.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions