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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you define user defied event?

794


Sequence generator, when you move from develoment to production how will you reset

1610


How to go to the older version for a mapping?

764


Global and Local shortcuts. Advantages.

1638


What all join we can perform in LOOKUP transformation?

728






State the limitations where we cannot use joiner in the mapping pipeline?

726


What is parallel processing in informatica?

1252


Mention some types of transformation?

778


Explain constraint based loading in informatica

815


When do you use sql override in a lookup transformation?

751


How to update a particular record in target with out running whole workflow?

1325


What are session parameters ? How do you set them?

1539


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

796


Enlist few areas or real-time situations where informatica is required.

780


expain about the tune parameters?

2100