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
What is the fact table?
Could you explain what is enterprise data warehouse?
tell me 5 session failure in real time how can you solve that in your project?
What is workflow? What are the components of workflow manager?
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
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?
Define pmcmd command?
How do you use reject loader.
can we override a native sql query within informatica? Where do we do it?
How to implement security measures using repository manager?
Define sessions in informatica etl?
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?
What are the transformations that are not supported in mapplet?
What is the advantage of informatica?
What are data-driven sessions?