Amazon Redshift Connector Best Practices

Amazon Redshift Connector Best Practices

Benefits of Using Pushdown Optimization

Benefits of Using Pushdown Optimization

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.

0 COMMENTS

We’d like to hear from you!