Consider the following rules and guidelines when you configure
SQL ELT optimization
for an Oracle mapping:
When you push transformation logic to the database,
ensure that the database has enough resources to process the queries faster.
Otherwise, there could be a performance degradation.
You can't use
Generate SQL
Query
in the
SQL ELT Query
panel to generate
and preview the SQL queries that
Data Integration
pushes to
the database.
When you use multiple objects as the
source type in a mapping, the mapping might fail with the following
error:
ASK INFAPreview
