Database Reference
In-Depth Information
Chapter 7. The Lifeline of Informatica -
Transformations
Transformations are the most important aspect of the Informatica PowerCenter tool. The
functionality of any ETL tool lies in transformations. Needless to say, transformations are
used to transform data. Informatica PowerCenter provides multiple transformations, each
serving a particular functionality. Transformations can be created as reusable or nonreus-
able based on the requirement. The transformations created in Workflow Manager are non-
reusable, and those created in the task developer are reusable. You can create a mapping
with a single transformation or with multiple transformations.
When you run the workflow, Integration Services extracts the data in a row-wise manner
from the source path/connection you defined in the session task and makes it flow from the
mapping. The data reaches the target through the transformations you defined.
The data always flows in a row-wise manner in Informatica no matter what your calcula-
tion or manipulation is. So if you have 10 records in source, there will be 10 source to tar-
get flows while the process is executed.
