Notes

Myth of the data readiness 

There’s always requests for querying the readiness of the data, particularly when it involves data synchronization between several databases.  In practices, the report design can help in the above myths.  The best design that I came across is the information of the report generation like report generation time stamp, user id will even be recorded when the user trigger the generation of report into a log table.  This helps a lot when answering the above user queries.  But of coz’ this will increase database size which implies cost impact.

Leave a Reply