When an Informatica PowerCenter domain has multiple nodes then workflows and sessions can be configured to run on a
Informatica allows SQL to be executed in the source database and the results can be pulled by the PowerCenter.
The key range partitioning in Informatica distributes rows of data based on a port or set of ports that
In pushdown optimization the Informatica Integration Service pushes the transformation logic to a database called active database and when
Informatica tracing levels can be configured at the transformation session levels and has 4 different types of tracing levels.
Stored Procedure Transformation in Informatica is a passive transformation and can be used in both connected and unconnected mode.