Update Override for PowerExchange for PostgreSQL for PowerCenter
Update Override for PowerExchange for
PostgreSQL for PowerCenter
Effective in 10.5.9, you can choose to update override for PowerExchange for PostgreSQL
for PowerCenter. You can specify custom SQL update queries for PostgreSQL targets in
PowerCenter mappings.
Update override provides improved performance by sourcing data directly from the
connector’s source table instead of in-memory buffers. Update override supports advanced
migration scenarios and enables seamless transition from a source, such as Oracle to
PostgreSQL.
For more information about how to update override for PostgreSQL, see the
Informatica®
PowerExchange for PostgreSQL 10.5.9 User Guide for PowerCenter