Extract-transform-load processor controller

A method of operating a controller for an Extract-Transform-Load (ETL) processor connected to one or more first data storage devices and adapted to render contextual assistance to a user on a display device, the method comprising:

• storing, by a storage control component on a hardware storage device, a set of criteria for preferredness of ETL stage placements, wherein the storage control component is implemented by one or more processors;
• recognizing, by an I/O input device detecting component, a proposed placement of a stage on a GUI canvas on the display device, wherein the I/O input device detecting component is implemented by one or more processors;
• analyzing, by an analytical component, an eventual result of the proposed placement in an ETL activity represented on the GUI canvas, wherein the analytical component is implemented by one or more processors;
• comparing, by a comparator, the eventual result of the proposed placement in the ETL activity with the set of criteria, wherein the comparator is implemented by one or more processors;
• and
• responsive to an outcome of an operation of the comparator, providing, by an indicator control component, to the user an indicator of a degree of preferredness of said proposed placement according to the set of criteria, wherein the indicator control component is implemented by one or more processors.

A computer program product for operating a controller for an Extract-Transform-Load (ETL) processor connected to one or more first data storage devices and adapted to render contextual assistance to a user on a display device, the computer program product comprising a non-transitory computer readable storage medium having program code embodied therewith, the program code readable and executable by a processor to perform a method comprising:

• storing, by a storage control component on a hardware storage device, a set of criteria for preferredness of ETL stage placements;
• recognizing, by an I/O input device detecting component, a proposed placement of a stage on a GUI canvas on the display device;
• analyzing, by an analytical component, an eventual result of the proposed placement in an ETL activity represented on the GUI canvas;
• comparing, by a comparator, the eventual result of the proposed placement in the ETL activity with the set of criteria;
• and
• responsive to an outcome of an operation of the comparator, providing, by an indicator control component, to the user an indicator of a degree of preferredness of said proposed placement according to the set of criteria.