[
http://mifosforge.jira.com/browse/MIFOSBI-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
johnwoodlock updated MIFOSBI-118:
---------------------------------
Summary: Add timestamps to mifos tables loan_schedules &
customer_attendance to benefit ETL incremental updates (was: Add timestamps to
mifos tables loan_schedules & customer_attendance to benefity ETL incremental
updates)
> Add timestamps to mifos tables loan_schedules & customer_attendance to
> benefit ETL incremental updates
> ------------------------------------------------------------------------------------------------------
>
> Key: MIFOSBI-118
> URL: http://mifosforge.jira.com/browse/MIFOSBI-118
> Project: mifos business intelligence
> Issue Type: Story
> Components: Data Warehouse
> Affects Versions: Mifos BI 1.0 BETA - Iteration 12, Mifos BI 1.0 BETA
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Fix For: Mifos BI 1.0 BETA - Iteration 12, Mifos BI 1.0 BETA
>
>
> 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
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
