ETL Components

ETL project components includes Source, Transformation, Lookup, Staging, Destination, and Loader components.

  • Source components – deliver data for a transformation stream. A project typically starts with one or more source components. Source components have no input ports and at least one output port.

  • Transformation components, Lookup components, and Staging components – apply specific transformations to the data in the transformation stream. These types of components have both input ports and output ports.

  • Destination components (also called data sinks) – write data to specific targets. Destination components have one input port and no output ports.

  • Loader components – extract and load data from a source database or file into the IQ database, without performing any transformation.