Versions Compared

Old Version 8

changes.mady.by.user johnwoodlock

Saved on

compared with

New Version 9

changes.mady.by.user johnwoodlock

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Basic Copy Data and Status Tests

Requirement

Test

Result

The ETL job should copy Copy over the simple 'dimensions' such as products,
currencies currencies, offices, personnels correctly
Notes
Note:
It is possible to create queries to test this more exactly.  
I didn't this time because I've used this simple area a lot and chose
to only do inspection so as to spend more time on the riskier areas  (customers, accounts and transactions).

Setup up an office hierarchy, some loan and savings products, some system users (loan officer and non loan officers) and run ETL

Pass.  
Looked good on simple inspection using queries and also current reports.

 

 

 

 

 

 

 

 

 

 

 

 

...

Handle being run against an initialised mifos database

...


Note:
This requirement is just in case this edge case produced unexpected results.  When testing, had to ensure the ETL job points to the correct source and destination database names by inspecting and editing the initialise dataware house 'bat' file I used and the jndi settings for kettle and the jndi setting

...

for the bi server

...

(for running reports)

run ETL against an initialised mifos 1.6.1 database

...

Pass

 

 

 

 

 

 

 

 

 

Requirement
The ETL should handle simple hierarchy (loan officer, center, group, client, loan/savings account) creation which involves new entries and catering for status changes when making groups, clients and accounts active.  Also clients without group membership and group without a center hierarchy should be 
Test - setup a center hierarchy down to clients having loan and savings accounts
Result
Pass.  All new customers and accounts are added to the datawarehouse as expected
Requirement
The ETL should handle when a client without a group membership is created and has its status changed and has a loan and a savings account.
Test
Client:  BO 1 / client w/o group mem xxx 0003-000000028
Savings: savings product 1 # 000100000000052 
Loan: loan prod 1 # 000100000000053 
Result
Pass. new client and accounts are added to the datawarehouse as expected
Requirement
The ETL should handle when a group without center hierarchy is created and has its status changed and has a client with a loan and a savings account and has its own savings and loan account as well.
Test
Group: group w/o center hierarchy 0004-000000029 
Group Loan: group load # 000100000000055 
Group Savings: group savings product # 000100000000056 
Client: client of group w/o center xxx 0004-000000030
loan: loan prod 1 # 000100000000059
Savings: savings product 1 # 000100000000058 
Result
Pass.new group, client and all accounts are added to the datawarehouse as expected
Requirement
The ETL should handle when a center has a savings account.
Test
Center: center with savings a/c 0004-000000031
savings: center savings # 000100000000061 
Result
Pass. Center and savings account added as expected.
Basic Copy Data and Status Tests

...