Invention Grant
- Patent Title: Validating code of an extract, transform and load (ETL) tool
- Patent Title (中): 验证提取,转换和加载(ETL)工具的代码
-
Application No.: US14954114Application Date: 2015-11-30
-
Publication No.: US09547702B2Publication Date: 2017-01-17
- Inventor: Rokky Vilakkumadathil
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent John Pivnichny
- Main IPC: G06F9/45
- IPC: G06F9/45 ; G06F17/30 ; G06F11/36 ; G06F9/445

Abstract:
An approach for validating code for an extract, transform and load tool is provided. Naming, coding, and performance standards for the code are received. The code is exported to a job definition file and parsed. Violations of the standards are determined by a mismatch between the parsed code and the standards. A report identifying the violations is generated. Based on a review of the report and a rework of the code to comply with the standards, the reworked code is exported to another job definition file and parsed, and subsequently is determined to not include the violations of the standards. A second report is generated that indicates the reworked code does not include the violations. An approval of the reworked code is received based on the second report. Based on attributes of a job included in the code, a violation of one of the performance standards is determined.
Public/Granted literature
- US20160078113A1 VALIDATING CODE OF AN EXTRACT, TRANSFORM AND LOAD (ETL) TOOL Public/Granted day:2016-03-17
Information query