An extract-transform-load (ETL) processor controller indicates a degree of preferredness of a proposed placement of data

摘要

A controller 100 for an Extract-Transform-Load (ETL) processor 102 is adapted to render contextual assistance on a display device to a user. The controller comprises a storage control component 106 for storing on a further storage device a set of criteria for preferredness of ETL stage placements; an I/O input device 110 detecting component for recognising a proposed placement of a stage on a GUI canvas on the display device; an analytical component 112 for analysing an eventual result of the proposed placement in an ETL activity represented on the GUI canvas; a comparator 114 for comparing 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, an indicator control component 116 for providing an indication of a degree of preferredness of a proposed placement of data