[
http://mifosforge.jira.com/browse/MIFOS-4286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
johnwoodlock updated MIFOS-4286:
--------------------------------
Summary: Add timestamps to mifos tables to benefit ETL incremental updates
(was: Add timestamps to mifos tables loan_schedules & customer_attendance to
benefit ETL incremental updates)
> Add timestamps to mifos tables to benefit ETL incremental updates
> -----------------------------------------------------------------
>
> Key: MIFOS-4286
> URL: http://mifosforge.jira.com/browse/MIFOS-4286
> Project: mifos
> Issue Type: Story
> Components: Reports Module
> Affects Versions: Release 2.0.0
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Fix For: Elsie F
>
>
> loan_schedule and customer_attendance are 2 tables which are brought into the
> Data Warehouse.
> Although there are dates on these tables, I can't find anything sensible that
> allows me to know the 'system' date that records are added or updated to them.
> A timestamp column is a simple way to allow this.
> Without the timestamp I have to clear down the DW version and copy all of
> their data over each time. Not a major problem for small MFI's (even Secdep)
> but would be for bigger ones.
> It would be best to add this to Release E to get it out of the way and not
> have it on our backlog. However, if it isn't done in Release E we'd tackle
> it the same way we will tackle 1.6 use of DW. We'd manually add the
> timestamp before we put the DW live on an MFI (part of the data quality
> check). And then when we eventually get round to putting it onto the mifos
> schema formally... the upgrade has to check that the column isn't already
> there.
> May be similar thing for PPI surveys but not sure yet (waiting to talk to Van)
> work involved is very simple but we'd have to time it for a big MFI like GK
> to see how much it might add to their upgrade (I don't think its huge but
> they are big tables at GK)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
