Why expression transformation is passive

Tags: Informatica. Shahid4u May 10, 0 Comments. Hi Friends, Can some one help me to understand how we conclude a transformation is active or passive. Shahid4u Posted May 10, 0 Comments. Sayantan Pramanik Posted May 10, 0 Comments. Cheers Sayantan. Anil Kaushal Posted May 10, 0 Comments. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password.

Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Choose incoming fields Step 2. Configure field selection criteria Step 3. Rename fields Step 4. Transformations Transformations Back Next.

Active and passive transformations. An active transformation can change the number of rows that pass through the transformation. For example, the Filter transformation is active because it removes rows that do not meet the filter condition.

A passive transformation does not change the number of rows that pass through the transformation. You can connect multiple branches to a downstream passive transformation when all transformations in the branches are passive.

You cannot connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group.

You might not be able to concatenate the rows. Once the expression for the field is valid. Click Ok to return to the Properties View of Expression. The expression can be used with any input ports or fields of available ports for the data manipulation operations. On the Expression properties window, the field level expression will be shown.

Save the mapping to apply the expression. The output or variable ports can be used to propagate the transformed data to the subsequent transformation or to the target system in the mapping. Similarly, there are various ways to use the expression that is implemented based upon the business requirements and according to the target systems. The expression transformation is very useful to develop the custom business logic and apply it to transform the source data and load it on that target system.

Because of the variety of features. This transformation is a mostly used transformation in the Informatica mappings and used for complex data manipulation. This is a guide to Expression Transformation in Informatica. Here we discuss the introduction and how to perform expression transformation in informatica?

You may also have a look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy.

Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.