top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Filter Transformation

+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?

posted May 25, 2015 by Sachin

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

1 Answer

0 votes

I checked result.

Case 1: when you use filter condition sal=true

nothing will be moved to target table. session succeeded
but no data in target table.

Case 2: when you use only TRUE as filter condition.

all 10 records from source passes through filter to target
table .(in target table also we will get 10 records)

answer May 26, 2015 by Manikandan J
Similar Questions
+3 votes

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

0 votes

What are the the situations where we will use the Source Filter, Select Distinct and Number Of Sorted Ports properties of Source Qualifier transformation.

+1 vote

I have been trying this since a week now. But I would like to use Filter Transformation or any alternative way to Filter records in Informatica Developer (Informatica Data Quality).

I have a field called Output which is generated in a Mapplet which contains two cases, 'pass' or 'fail'

I would like to view the results of only fail records.

Is there a way I can do this using a Mapplet?

Thank you.