Projects:Configurable Update Analytics Fact Tables Process/QA
Manual Tests
Different manual tests have been done along this project, testing different combinations for the process configuration.
It has been put special attention on boundaries, i.e., the behavior on those fact records related to the dates defined as the limits of the process execution.
This is the summary of individual executions of the Forward and Backward processes for every possible configuration:
Forward Start Date | Forward Batch Size | Backward Start Date | Backward Batch Size | Forward Process | Backward Process | Test Result |
Not defined | Not defined | Not defined | Not defined | Calculated all fact records | Nothing calculated. Detected an invalid configuration. | OK |
09-06-2015 | Not defined | Not defined | Not defined | Calculated all fact records from 09-06-2015 until now. Records for 09-06-2015 are created. | Calculated all fact records from the beginning until 09-06-2015. Records for 09-06-2015 are not created. | OK |
Not defined | 100 | Not defined | Not defined | Calculated the first 100 fact records. | Nothing calculated. Detected an invalid configuration. | OK |
09-06-2015 | 100 | Not defined | Not defined | Calculated the first 100 fact records starting from 09-06-2015. Records for 09-06-2015 are created. | Calculated all fact records from the beginning until 09-06-2015. Records for 09-06-2015 are not created. | OK |
09-06-2015 | 100 | 05-05-2015 | Not defined | Calculated the first 100 fact records starting from 09-06-2015. Records for 09-06-2015 are created. | Calculated all fact records between 05-05-2015 and 09-06-2015. Records for 05-05-2015 are created. Records for 09-06-2015 are not created. | OK |
09-06-2015 | 100 | Not defined | 100 | Calculated the first 100 fact records starting from 09-06-2015. Records for 09-06-2015 are created. | Calculated the last 100 records previous to 09-06-2015. Records for 09-06-2015 are not created. | OK |
09-06-2015 | 100 | 05-05-2015 | 100 | Calculated the first 100 fact records starting from 09-06-2015. Records for 09-06-2015 are created. | Calculated the last 100 records between 05-05-2015 and 09-06-2015. Records for 05-05-2015 are created if reached with batch size. Records for 09-06-2015 are not created. | OK |
Together with this, it has also been tested the following:
- If there not exists any configuration, all the fact records are created when launching the Forward process.
- If there not exists any configuration, the Backward process detects it and it does not create anything.
- It is not possible to create a configuration having a backward start date greater or equal than the forward start date.
- If the batch size is 0, no records are created.