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
Differentiate between sessions and batches?
What is informatica etl tool?
Can we create two repositories on same database instance in oracle?
can u any challenge your project?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What do you mean incremental aggregation?
Differentiate between source qualifier and filter transformation?
Explain the features of connected and unconnected lookup.
design of staging area?
What is complex mapping?
What are roles and groups and benefits of using them?
What do you mean by blocking transformation?
Define mapping and session?
How we can use union transformation?
Differences between version 7.x and 8.x.