Method and Apparatus for Generating Code for an Extract, Transform, and Load (ETL) Data Flow
First Claim
1. A computer-implemented method for generating code for an extract, transform, and load (ETL) data flow in an ETL system, the method comprising:
- receiving an ETL data flow representing a logical transformation and flow of data;
placing a staging table at a pre-determined location in the ETL data flow to reduce a total number of staging tables required by the transformation; and
generating code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location.
1 Assignment
0 Petitions
Accused Products
Abstract
Methods, computer program products, and system for generating code for an extract, transform, and load (ETL) data flow are provided. In one implementation, the method includes receiving an ETL data flow representing a logical transformation and flow of data, placing a staging table at a pre-determined location in the ETL data flow to reduce a total number of staging tables required by the transformation, and generating code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location.
-
Citations
20 Claims
-
1. A computer-implemented method for generating code for an extract, transform, and load (ETL) data flow in an ETL system, the method comprising:
-
receiving an ETL data flow representing a logical transformation and flow of data; placing a staging table at a pre-determined location in the ETL data flow to reduce a total number of staging tables required by the transformation; and generating code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer program product, tangibly stored on a computer-readable medium, for generating code for an extract, transform, and load (ETL) data flow in an ETL system, the computer program product comprising instructions for causing a programmable processor to:
-
receive an ETL data flow representing a logical transformation and flow of data; place a staging table at a pre-determined location in the ETL data flow to reduce a total number of staging tables required by the transformation; and generate code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location. - View Dependent Claims (13, 14, 15, 16, 17, 18)
-
-
19. An extract, transform, and load (ETL) system comprising:
-
a code generation system to receive an ETL data flow representing a logical transformation and flow of data; a first engine associated with the code generation system to place a staging table at a predetermined location in the ETL data flow to reduce a total number of staging tables required by the transformation; and a second engine associated with the code generation system to generate code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location. - View Dependent Claims (20)
-
Specification