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