how to delete duplicate records by using filter
transfermation?
Answer Posted / venkateshmalneni
by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it
in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Differentiate between Load Manager and DTM?
what is the -ve test case in your project.
what is size of u r database?
What is the meaning of up gradation of repository?
What is a shortcut and copy in Informatica and how two are different with each other?
How can we create index after completion of load process?
What is update strategy transform?
Explain transaction control transformation in informatica
Explain what transformation and how many are there in informatica?
What is data movement mode in Informatica and difference between them?
What are the types of caches in lookup?
What is the difference between a repository server and a powerhouse?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
In informatics server which files are created during the session rums?
What all are steps in up gradation of Informatica server?