The following lists the benefits of using pushdown optimization:
Performance
. The optimal and most appropriate load balancing between Informatica server and Amazon Redshift engine resulting in significant performance gains.
Productivity
. Utilizes the same metadata driven interface and architecture.
No coding
. Eliminates the need to write complex SQL statements or code.
Scale
. Effectively leverages high performance data warehouse engine.
Backward compatible and future proof
. Pushdown optimization works with latest version of Amazon Redshift engine. Future versions of ODBC pushdown optimization for Amazon Redshift incorporates new functionality.
SLA
. Makes data available on time.
OLTP acid properties
. The ODBC pushdown optimization combines all the statements into a single
BEGIN … COMMIT;
statement that ensures transaction control and data integrity.