Hello! Can somebody explain me please! What is the difference using an Elt component vs. a "Specific" component? (example: tMySqlInput vs tELTMySqlInput). I have done many mapping examples (using tMap, respectively tEltMySqlMap) using tMySql components and tELTMysql components, but maybe there are some specific jobs that restrict the usage of both!?
ELT mode use DB server to run SQL query, only SQL statements are used to transform and load data on the same DB tDBinput get data flow from DB to the job, all java functions, talend routine and connectors are available to transform data