Automating extract, transform, and load job testing
US10042903B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 2, 2015 |
| Grant date | Aug 7, 2018 |
| Priority date | — |
| Expiry date | Apr 3, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/254
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.