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
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
...