top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Fillter transformation condition

0 votes
197 views

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 11, 2015 by Sachin

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

1 Answer

0 votes

1

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 # 2

nothing will happen when we use filter option it just check
the source record where all record are salary records or nor

answer May 11, 2015 by Manikandan J
Similar Questions
+1 vote
Under what condition selecting Sorted Input in aggregator may fail the session?

Under what condition selecting Sorted Input in aggregator may fail the session?

+1 vote
update strategy expression DD_UPDATE AND (condition)

What this means? DD_UPDATE and ($$export_agreement =0 OR $$export_agreement =1)

i can't find anything regarding the "and" condition.

thank you very much!

0 votes
Informatica sending E-Mail on a condition

I have a table say X with the below structure

COLUMN1    COLUMN2
1            T
2            F
3            T
4            T
5            F

I want to send an E-MAIL to a specific mail-id saying 'PASS' if there is no 'F' in COLUMN2 and an E-MAIL saying 'ALERT' if there is even a single 'F' in column2.

...