Question

Differentiate between ETL and ELT.in Talend?

Answer 1

ETL	ELT
1. Data is first Extracted, then it is Transformed before it is Loaded into a target system	1. Data is first Extracted, then it is Loaded to the target systems where it is further Transformed
2. With the increase in the size of data, processing slows down as entire ETL process needs to wait till Transformation is over	2. Processing is not dependent on the size of the data
3. Easy to implement	3. Needs deep knowledge of tools in order to implement
4. Doesn’t provide Data Lake support	4. Provides Data Lake support
5. Supports relational data	5. Supports unstructured data