Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7978 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / mahaboob basha
connot delete the duplicate records while using filter t/r
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / devendar pd
if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.
I think we can't remove duplicates only by using filter
| Is This Answer Correct ? | 1 Yes | 1 No |
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
What is pmcmd command?
what is filelist concept in informatica
What is a difference between complete, stop and abort?
What is informatica powercenter repository?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
Types of error logs in Informatica?
What is primary and backup node?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
what is workflow varible
How will u pas the data with out debugger?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Teradata 
