[
http://mifosforge.jira.com/browse/MIFOSBI-218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
johnwoodlock resolved MIFOSBI-218.
----------------------------------
Resolution: Fixed
Story Points: 2
Wiki page referenced in this issue contains write-up and attachments for:
'pre ETL check' script to run on a mifos database
'post ETL check' job to run against a data warehouse db
and a troubleshooting script to use stage 1 if the ETL falls over.
The scripts can be added to as and when extra types of data quality problems
are identified.
> create a BI Data Health tool to evaluate whether an OLTP database is in a
> good enough state to run the ETL on it
> ----------------------------------------------------------------------------------------------------------------
>
> Key: MIFOSBI-218
> URL: http://mifosforge.jira.com/browse/MIFOSBI-218
> Project: mifos business intelligence
> Issue Type: Story
> Components: Data Warehouse
> Reporter: Van Mittal-Henkle
> Assignee: johnwoodlock
> Priority: Major
> Fix For: Mifos BI 1.2
>
>
> This could be something as simple as a sql script initially that includes
> queries that would catch the cases we are aware of so far of problems with
> data consistency in Mifos OLTP databases.
> The idea is that if an OLTP database doesn't pass the health check then we
> know that the database needs cleanup before it is ready to run the ETL jobs.
> This could be used during and at the end of data migration to ensure that
> data is being set up in a consistent way.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
