Pushdown optimization, also known as ELT, is a server load-balancing technique that maximizes the performance of integration processes. It extracts, loads, and transforms data – enabling users to choose whether the data processing takes place in the source or target database.
By placing the staging table in the database, it eliminates the unnecessary data movement and reduces network latency, cutting down the overall execution time.
Pushdown optimization modes can be categorized into two types:
1- Partial Pushdown: In this mode, the transformation logic is partially pushed down to the source or destination database, depending on the database provider.
2- Full Pushdown: It pushes down transformation logic completely to the database, executing the job in pushdown mode from beginning to end.
Learn more about pushdown optimization
Back To Top