top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica integration service treats filter transformation as passive transformations?

+3 votes
277 views

Does the integration service treat the filter or update transformation as passive transformations ?

posted Oct 20, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Filter as well update strategy are both active. By definition any transformation that changes the number of rows passing thru it is active. Filter txfn does exactly this.

Update strategy is considered active because it changes row type. Although it doesn't by itself change the number of rows, it marks the rows for delete, insert or update producing the same result.

answer Oct 27, 2014 by Shweta Singh
Similar Questions
+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+1 vote

What is Active and Passive transformation in Informatica?

+1 vote

What are the transformations that cannot be placed between the sort origin and the Joiner transformation so that we do not lose the input sort order.

+1 vote

In source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target? what will happen?

...