how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14599 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
Can you use flat files in Mapplets.
In how many ways we can create ports?
Explain the shared cache and re-cache?
Explain what are the different versions of informatica?
How are the sources and targets definitions imported in informatica designer?
What are the different options available for update strategy?
What is workflow? What are the components of the workflow manager?
tell me 5 session failure in real time how can you solve that in your project?
What does command task mean?
What is lookup change?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is dimensional table?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is the hint? how to use it to reduce the query processing in program?
What is an aggregator transformation?
