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
What are the ways for deleting duplicate records in Informatica?
Home
Informatica
What are the ways for deleting duplicate records in Informatica?
0
votes
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
What are the ways for deleting duplicate records in Informatica?
duplicate-records
informatica-records
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jun 6, 2021
by
rajeshsharma
There are several ways for deleting duplicate records in Informatica. They are as follows:
1. Making use of select distinct in source qualifier
2. Making use of group and aggregator by all fields
3. By overriding SQL query in source qualifier
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
0
votes
Q: Define different ways used in Informatica to migrate from one environment to another?
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
informatica-migrate
informatica-environment
+3
votes
Q: How can you delete duplicate records in a table with no primary key?
asked
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
0
votes
Q: What are the different mapping design tips for Informatica?
asked
May 23, 2023
in
Informatica
by
SakshiSharma
informatica
mappingdesign
0
votes
Q: What are the different types of methods for the implementation of parallel processing in Informatica?
asked
May 23, 2023
in
Informatica
by
SakshiSharma
parallel
processing
informatica
0
votes
Q: What are the different ways to remove duplicate service registration?
asked
Sep 22, 2023
in
Angular
by
AdilsonLima
angularjs-interview-questions-answers
0
votes
Q: What is the data format u prefer for informatica server.
asked
Feb 26, 2023
in
Informatica
by
rajeshsharma
informatica
+1
vote
Q: What is the difference between Soft delete and Hard delete of Salesforce records? How to enable them from Informatica Cloud?
asked
Sep 27, 2022
in
Salesforce
by
SakshiSharma
salesforce-records
0
votes
Q: What are the output files created by the Informatica server at runtime?
asked
May 26, 2023
in
Informatica
by
sharadyadav1986
informaticaserver
0
votes
Q: In Informatica, how many numbers repositories are possible to be made?
asked
May 23, 2023
in
Informatica
by
SakshiSharma
repositories
informatica
0
votes
Q: Name the tables that are linked with staging data in Informatica MDM?
asked
Jun 7, 2021
in
Informatica
by
rajeshsharma
informatica-mdm
mdm-staging-data
...