One Star

ELT vs "Specific" components

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!?
1 REPLY
Employee

Re: ELT vs "Specific" components

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