Purpose of the ELT Talend Components :
The ELT Talend components (Input, Mapper and Output) are useful for bulk loading the tables by pushing the processing overhead to the Database server rather than iterating through the resultsets in memory.
Example ELT Components for MYSQL.
The three components (input, map, output) are closely tied and have to be used together.
- tELTMySqlInput
- tELTMySqlMap
- tELTMySqlOutput
- The main purpose of the ELT components is PERFORMANCE.
- Bulk read/insert into tables by using different tables and all types of JOINS, WHERE clauses and GROUP BY and HAVING clauses.
What can you NOT do with ELT Components :
- You cannot JOIN tables from different SCHEMAS which means that the tables should be sourced from the same database schema.
Things to keep in mind when using the ELT_Mapping component
It always helps to check the SQL generated for us in the "Generated SQL" tab of editor of the ELT_Mapping component for syntax errors.
Happy Talending!
