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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the fact table?

743


Could you explain what is enterprise data warehouse?

723


tell me 5 session failure in real time how can you solve that in your project?

1849


What is workflow? What are the components of workflow manager?

876


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1922






One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1961


Define pmcmd command?

783


How do you use reject loader.

2280


can we override a native sql query within informatica? Where do we do it?

836


How to implement security measures using repository manager?

783


Define sessions in informatica etl?

755


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1856


What are the transformations that are not supported in mapplet?

765


What is the advantage of informatica?

804


What are data-driven sessions?

912