Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7787 Views
- I also Faced
- E-Mail Answers
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
How to load last n records of file into target table - informatica
What are the prerequisite tasks to achieve the session partition?
Explain the shared cache and re-cache?
Define filter transformation?
What is a surrogate key?
What are the types of schemas we have in data warehouse.
How can we handle two sessions in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
How we can create indexes after completing the loan process?
which one is better performance wise joiner or look up
how to load rows into fact table in data warehouse
How can we use mapping variables in informatica? Where do we use them?
What are the different options available for update strategy?
What are the types of presistent cache in look up tr.
What is complex mapping?
