in Big Data | Hadoop by
Q:

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.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked May 27, 2019 in Other by tempuser
0 votes
asked Mar 22, 2020 in Big Data | Hadoop by SakshiSharma
+1 vote
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Dec 6, 2020 in Data Handling by rajeshsharma
...