Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 8102 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
What do you mean by channel change?
What can we do to improve the performance of informatica aggregator transformation?
What is an active transformation?
What is the use of an aggregator cache file?
How can you generate reports in informatica?
Repository user profiles
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to call shell scripts from informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Enlist the tasks for which source qualifier transformation is used.
What is the function of aggregator transformation?
What is enterprise data warehousing?
what is the size of u r source(like file or table)?
Differences between connected and unconnected lookup?
Explain the scenario which compels informatica server to reject files?
