Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7790 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 have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Explain the different lookup methods used in informatica?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
How to delete duplicate records in a flat file source?
Where should yoU place the flat file to import the flat file defintion to the designer?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
what is inline view?
How we can use union transformation?
what is system requirement(SR) & business requirement(BR)?
What is a snowflake schema?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Teradata 
