Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 8110 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 |
what is target update override and when we use it?
Explain transaction control transformation in informatica
Diffrence between static and dynamic cache
difference between source based commit? and target based commit? which is better with respect to performance?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Can we update a target table (without primarykey) by using update strategy transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is an expression transformation?
What is the difference between Normal load and Bulk load?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Teradata 
