Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14948 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 limitations of joiner transformation?
what are the Methods For Creating Reusable Transformations?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What do you understand by a term domain?
What is informatica etl tool?
What does refresh system mean, and what are its distinctive choice?
What is repository manager?
How to create or import flat file definition in to the warehouse designer?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain about cumulative Sum or moving sum?
How union transformation is used?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a sorter transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
