how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14625 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.
once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.
2.) with out using sorter
in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the data movement modes in informatica?
What are the components of the workflow manager?
How might one distinguish in the case of mapping is right or not without associating session?
Define sessions in informatica etl?
How to delete duplicate row using informatica?
What is a stored procedure transformation?
Explain lookup transformation source types in informatica
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Explain the tuning lookup transformation - informatica
what is mean by complex business rule ?
How do you update the records with or without using update strategy?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the different types of transformation available in informatica.
