Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14938 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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain how to import oracle sequence into informatica?
Briefly describe lookup transformation?
What are the different types of repositories created using informatica?
Which development components of informatica have the highest usage?
What is the cumulative sum and moving sum?
What could be the possible resons of locks by user?
How might you approve all mappings in the archive all the while?
What are the transformations that are not supported in mapplet?
Explain why we use partitioning the session in informatica?
How to handle decimal places while importing a flatfile into informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
How many number of sessions can one group in batches?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
