1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What will happen if we have a filter transformation used in
a mapping and in the filter condition we specify 1. Yes
nothing else, only the number 1. In other words, assuming we
have 10 rows coming to this filter transformation as an
input, how many rows will be output by this transformation
when we have only 1 in the filter condition?

Question Posted / guest

Answers were Sorted based on User's Feedback



What will happen if we have a filter transformation used in a mapping and in the filter condition w..

Answer / schwab

Yes Ur right
0 represent FALSE and
all NON-Zero numbers are TRUE.

Answer to above question is all 10 rows will be inserted.

Is This Answer Correct ?    21 Yes 2 No

What will happen if we have a filter transformation used in a mapping and in the filter condition w..

Answer / sriveni

1 Represents TRUE and 0 represents FALSE

Letme Know if i am wrong

Is This Answer Correct ?    13 Yes 1 No

What will happen if we have a filter transformation used in a mapping and in the filter condition w..

Answer / sudha

As 1 represent TRUE condition the filter will return all
the rows that pass through it without any filtration.
here all 10 rows will be the output and by default filter
condition is 1.

Is This Answer Correct ?    6 Yes 2 No

What will happen if we have a filter transformation used in a mapping and in the filter condition w..

Answer / pavan

THE FILTER CONDITION IS 0 THE SESSION WILL BE FAIL
THE FILTER CONDITION IS NON ZERO MEANS LIKE 1,2,3....IS TRUE THEN IT PROCESS ALL THE ROWS WITH OUT FILTERING ANY DATA

Is This Answer Correct ?    2 Yes 1 No

What will happen if we have a filter transformation used in a mapping and in the filter condition w..

Answer / susanta

Can u plz tell me wat will happen if I give -3...

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1 Answers   Nationwide,

Which is costliest transformation? costly means occupying more memory?

3 Answers  

what is incremental aggregation ,with example?

2 Answers  

Explain lookup transformation in informatica

1 Answers   Informatica,

How mapping parameter and variable works

1 Answers  

How to join three sources using joiner?

1 Answers  

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

without using emailtask how will send a mail from informatica?

3 Answers  

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

What is A complex mapping?

3 Answers   TCS,

Which is better performance wise database or file?How?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories