how to duplicates from expression transformation without
using sorter before that
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
Partition, what happens if the specified key range is shorter and longer
What is the different lookup cache(s)?
How can we update a record in the target table without using update strategy?
Enlist the tasks for which source qualifier transformation is used.
Explain the types of transformations?
What is a pre-defined event and user-defined event?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to open an older version of an object in the workspace?
What is rank transform?
Enlist the advantages of informatica.
how to create user defined function (udf) in informatica
What is the format of informatica objects in a repository?
What is substr in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
What is a sequence generator transformation?