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 are junk dimensions?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Separate from an archive server and a powerhouse?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are connected or unconnected transformations?
What is the sequence generator transformation in informatica?
How can we use mapping variables in informatica?
What are the new features of informatica 9.x in developer level?
Difference between Target-based loading and constraint-based loading?
What is source qualifier transformation in informatica?
permutations of mapplet
Write the advantages of partitioning a session?