Login
Remember
Register
Ask a Question
How can we filter rows in Informatica?
+1
vote
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
How can we filter rows in Informatica?
Bigdata-questions-answers
Hadoop-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Mar 10, 2020
by
Hodge
There are two ways to filter rows in Informatica, they are as follows:
Source Qualifier Transformation
: It filters rows while reading data from a relational data source. It minimizes the number of rows while mapping to enhance performance. Also, Standard SQL is used by the filter condition for executing in the database.
Filter Transformation
: It filters rows within a mapped data from any source. It is added close to the source to filter out the unwanted data and maximize performance. It generates true or false values based on conditions.
...
