Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
How can we filter rows in Informatica?
Home
Big Data | Hadoop
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.
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
+1
vote
Q: How can we delete duplicate rows from flat files?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What can we do to improve the performance of Informatica Aggregator Transformation?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: In Informatica Workflow Manager, how many repositories can be created?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: The default limit to the number of rows returned by a query can be done using which of the following parameter?
asked
Apr 8, 2020
in
Big Data | Hadoop
by
GeorgeBell
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: What are the advantages of Informatica?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: Advantages of Teradata over Informatica
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: What are the advantages of using Informatica as an ETL tool over Teradata?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What are the features of Informatica Developer 9.1.0?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: Mention some typical use cases of Informatica.
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: What is Informatica PowerCenter?
asked
Mar 10, 2020
in
Big Data | Hadoop
by
Hodge
Bigdata-questions-answers
Hadoop-questions-answers
...