Transformation
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an filter transformation use for filter data.
(Read also: Informatica_interview Q&A)
Transformation mainly are 2 types
1)Active
2)Passive
Active Transformation
An active transformation can change the number of rows that pass through the transformation, change the transaction boundary, can change the row type. For example, Filter, Transaction Control are active transformations.
Passive Transformation
A passive transformation does not change the number of rows that pass through it, maintains the transaction boundary, and maintains the row type.For example Expression Transformation.
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an filter transformation use for filter data.
(Read also: Informatica_interview Q&A)
Transformation mainly are 2 types
1)Active
2)Passive
Active Transformation
An active transformation can change the number of rows that pass through the transformation, change the transaction boundary, can change the row type. For example, Filter, Transaction Control are active transformations.
Passive Transformation
A passive transformation does not change the number of rows that pass through it, maintains the transaction boundary, and maintains the row type.For example Expression Transformation.
Transformations can be Connected or UnConnected to the data flow.
Connected Transformation
Connected transformation is connected to other transformations or directly to target table in the mapping.
Passive Transformation
An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.
Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
ReplyDeleteRegards,
Informatica training in chennai|Informatica course in Chennai