Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7819 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 can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Why update strategy and union transformations are active? Explain with examples.
What is a stored procedure transformation?
What is the different lookup cache(s)?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is mapping debugger?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can u generate reports in Informatica?
How to use pmcmd utility command?
What are the uses of etl tools?
How to implement security measures using repository manager?
without table how to come first record only in oracle?
How to load data in informatica ?
What are the components of workflow manager?
how to load dimension table and fact table. plz tell me the steps.
