+1 vote
in Big Data | Hadoop by

How can we filter rows in Informatica?

1 Answer

0 votes
by

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.

Related questions

+1 vote
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
...