Tavant decided to offer Reporting as well as ETL solutions to the customerin an onsite-offshore model.Separate teams were formed for individual components of the project– Reporting and ETL. These teams were responsible for end-to-end testing of the components.
Subsequently, Tavant provided an automated file processing, reporting and analytics solution to the customer, which helped it analyze all the service data on a regular basis, and also aided in better and faster decision makings.
Test Execution/Automation
Tavant designed a functional test automation framework for the project, which included PL SQL, batch files and VB Scripts.
ETL Testing
Tavant conducted testing of the ETL process to make sure that all the appropriate rows were loaded, transformations were properly executed and cleansing was completed successfully.
Business Objects Reports Testing
Business Objects reports were tested by firing SQL queries based on report requirements and analyzing the resultset vis-à-vis the data.Subsequently, for testing the front end, on the basis of the report requirements,filters or prompts, and formatting, printing and exporting features of the report were validated. It also involvedverification of all variables and functions used in the reports.
Performance Testing
As the volume of data in a data warehouse grew, ETL load times also increased, causing a dip in the performance of queries. This was mitigated by ensuring solid technical architecture and efficient ETL design.
Query Performance Automation
The process of measuring SQL query response was automated by VB script, which triggered at a scheduled time through a batch file. It read the file from the folder in which SQL queries were stored and executed it. It created an Excel file with data on query start time, end time, execution time and the number of records fetched. It also providedan account of errors.
|
