What is an ETL please discus its component and cyclesSoluti

What is an ETL , please discus its component and cycles?

Solution

ETL STAND FOR Extract-Transform-Load .

ETL Components
ETL extend segments incorporates Source, Transformation, Lookup, Staging, Destination, and Loader component.

Source components– convey information for a change stream. A venture commonly begins with at least one source segments. Source parts have no information ports and no less than one yield port.

Change segments, Lookup parts, and Staging segments – apply particular changes to the information in the change stream. These sorts of segments have both information ports and yield ports.
Destination Component (additionally called information sinks) – compose information to particular targets. Goal parts have one info port and no yield ports.

Loader Component – concentrate and load information from a source database or document into the IQ database, without playing out any change.

Component Properties Setup
Set the required properties before utilizing any segment as a part of a venture.

Adding Descriptions to Components
You can allocate a name and a depiction to a part. The depiction and the name show up in the tooltip, which opens when you move your mouse over a segment. The name likewise shows up at the highest point of the segment.

Port Structure Configuration
All information in a venture moves through segment ports brought IN-ports, which get information, and yield ports, which pass the information in the wake of handling. Every port claims the structure of the information stream. You can change the port structures of all segments for which the structure is not straightforwardly subject to segment setup. You can reference credits added to the port structure promptly inside the part.

Component Simulation

Run an ETL extend in recreation mode to screen and approve the change procedure well ordered.

Database Connection Settings
Determine database association parameters in the Database Configuration window or Properties window.

Source Components
Source parts convey information for a change stream. A venture ordinarily begins with at least one source parts. Source parts have no IN-ports and no less than one OUT-port.

Transformation Components
Transformation parts have both info ports and yield ports and apply particular changes to the information in the change stream.

Lookup Components
A Lookup operation looks into an esteem that relates to a key in a query table that contains a rundown of key and esteem sets. A static query table can be reserved amid the execution of a venture, or a query can be performed uncached and powerfully.

Staging Components
Staging parts have no less than one info port and one yield port and apply particular changes to the information in the change stream.

Destination Components
Destination parts (additionally called data sinks) compose information to particular targets. This segment sort has one info port and no yield port.

Loader Components
Loader parts stack information from a source database or a document into the IQ database, without playing out any change.

ETL CYCLES ARE AS FOLLOWS: