The ETL transactions are needed to be divided to achieve better performance. This process is known as ETL partitioning. It makes sure that the server can directly access the sources through multiple connections.

BY Best Interview Question ON 26 Jan 2019