Database Reference
In-Depth Information
transformation work internally. Informatica has a
Push Down Optimization
(
PDO
)
feature that enables this. PDO allows developers to build mapping logic in the stand-
ard PowerCenter GUI development environment that is pushed to the database as
SQL at execution time. It gives the performance benefit of executing in the database
and the development and maintenance benefits of working in the PowerCenter cli-
ent.
For simple Greenplum to Greenplum data loads, consider using PDO over ODBC.
Note that not all PowerCenter logic can be pushed down to the database, so it will
be important to verify which business logic can be implemented successfully through
PDO. A limited number of transformations can be implemented using PDO over
ODBC.
Search WWH ::
Custom Search