This scenario shows you an example of aggregating Snowflake data from two source tables STUDENT and TEACHER to one target table FULLINFO using the ELT components.
For more technologies supported by Talend, see Talend components.
- tELTInput specifies input database table and schema. You can use multiple database tables as the input by connecting multiple tELTInput components to a tELTMap component and specifying a database table for each of the tELTInput components.
- tELTMap defines how the schema columns of the input database tables are mapped to the output columns. This component also allows you to set the mapping conditions.
- tELTOutput generates the SQL statement according to the mapping relationship defined in tELTMap and the actions (including action on table and action on data). The SQL statement is stored in the Query variable of the tELTOutput component.
In this example, context variables are used to hold all the input and output table names and connection names.