Difference between ETL and non ETL components

Four Stars

Difference between ETL and non ETL components

Hi All,

 

I am new to Talend, so it might be a stupid question to which i can not find an answer or may be i am not searching it right.

 

I noticed there are some normal components on the palette and a ETL version of the same component is also available. For example there is tMysqlOutput component available  in Mysql group and, a tETLMysqlOutput component is also available.

 

How are the normal components different from ETL components. Also i noticed that the Link Connector is only available for ETL components. Is there a reason for it?

Six Stars

Re: Difference between ETL and non ETL components

Hi Mohit,

 

ETL component i:e;  tETLMysqlOutput is basically used for insert,update,delete purpose only on the other hand  tMysqlOutput used only for the purpose of insert data into the datase table.

Regards
Aashish
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Difference between ETL and non ETL components

Thanks for responding Aashish. So what you are saying is tETLMysqlOutput is super set of tMysqlOutput. But the question arises than what is the need to tMysqlOutput when tETLMysqlOutput could do everything.

 

Does the same applies for all other ETL components as well.

Moderator

Re: Difference between ETL and non ETL components

Hello,

ELT has the advantage to avoid transferring the data outside the database but you lose the control over the flow and cannot say anything about the progress and of course it works only in ONE database which are connected to each other.

The ELT component should be used if you have a large amount of data. 

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.