Patent ID: 8452723

Claim:
A method for a workflow for an ETL (extraction, transformation, loading) process comprising operating a computer to perform steps of: displaying in a first area of a display system a view of a first data transformation from among a plurality of data transformations, the ETL process comprising the plurality of data transformations; displaying in a second area of the display system a view of input data received from a data source; displaying in a third area of the display system a view of output data generated by performing the first data transformation on the input data; receiving information from a user indicative of a change to the first data transformation to define a modified data transformation; in response to receiving the information from the user, displaying in the third area a view of output data generated by performing the modified data transformation on the input data; and conducting ETL data flow processing comprising: receiving input data from the data source; transforming the received input data in accordance with the modified data transformation to produce transformed data; and loading the transformed data in a data target.