Troubleshooting Informatica Error Messages and Resolution – Part 236

SQLServerF1

OPT_63120Pushdown optimization stops at the Aggregator transformation <transformation name> because there is an upstream Aggregator transformation.
Cause:The Aggregator transformation is the second Aggregator transformation in the pipeline. The Integration Service cannot generate SQL statements for more than one Aggregator transformation in a pipeline. This occurs because the SQL generated for two consecutive Aggregator transformations results in a nested Aggregator function, which cannot be processed on the database.
Action:None.

OPT_63131Pushdown optimization stops at the Joiner transformation <transformation name> because an input pipeline contains an Aggregator transformation.
Cause:An Aggregator transformation exists in an input pipeline. The database must perform join operations before aggregation operations, so the Integration Service cannot generate an SQL statement for a Joiner transformation that is downstream from an Aggregator transformation.
Action:None.
OPT_63133Pushdown optimization stops at the Joiner transformation <transformation name> because it is configured for an outer join and the master source joins multiple tables.
Cause:The master source joins multiple tables. The Integration Service cannot generate SQL to join multiple tables with an outer join.
Action:None.
OPT_63147Pushdown optimization stops at the Lookup transformation <transformation name> because it is downstream from an Aggregator transformation.
Cause:The Lookup transformation is downstream from an Aggregator transformation in the pipeline. The Integration Service cannot generate SQL statements for a Lookup transformation downstream from an Aggregator transformation.
Action:None.

OPT_63152Pushdown optimization stops at the Sorter transformation <transformation name> because the distinct key <port name> is not used downstream.
Cause:The Integration Service cannot generate SQL for a Sorter transformation configured for a distinct sort when the distinct key is not used downstream.
Action:None.
OPT_63157Pushdown optimization stops at the Union transformation <transformation name> because the sources use different database connections.
Cause:The Union transformations joins sources that are from different databases or that use different database connections.
Action:If the Union transformation joins sources from the same database, ensure that you specify the same database connection in the session properties.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *