Sunday, 28 October 2018

List of Active and Passive Transformations in Informatica?

Active and Passive Rule



1. Active Transformation:- An active transformation can perform any of the following actions:

(a) Change the number of rows that pass through the transformation
(b) Change the transaction boundary:.
(c) Change the row type:


2. Passive Transformation:- An Passive transformation which will satisfy all below conditions:

(a) Do not Change the number of rows that pass through the transformation
(b) Maintains the transaction boundary
(c) Maintains the row type.



3. Connected Transformations:- Transformations which are connected to other transformation in the data flow are called Connected Transformations

4. Unconnected Transformations:- Transformations which are not connected to other transformation in the data flow are called as Unconnected Transformations.An unconnected transformation is called within another transformation, and returns a value to that transformation.


   


No comments:

Post a Comment

Expression Transformation in Informatica

Expression transformation is a connected, passive transformation used to calculate values on a single row. Expression transformations ar...