Explain 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)?
Submitted by: AdministratorThere 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Reportnet Job Interview Questions And Answers
Top Reportnet Questions
☺ | Explain What is difference between query studio and report studio? |
☺ | How to generate the cubes in framework manager? |
☺ | What is the Difference between PowerPlay transformer and power play reports? |
☺ | Explain What is the Difference between PowerPlay transformer and power play reports? |
☺ | Explain Is there any comparison available for Cognos Reportnet Vs Crystal reports? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |