...
Basic Copy Data and Status Tests
Requirement | Test | Result |
---|---|---|
The ETL job should copy Copy over the simple 'dimensions' such as products, | Setup up an office hierarchy, some loan and savings products, some system users (loan officer and non loan officers) and run ETL | Pass. |
|
|
|
|
|
|
|
|
|
|
|
|
...
Handle being run against an initialised mifos database |
...
|
...
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
...