how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14294 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
A session S_MAP1 is in Repository A. While running the session error message has displayed
who is the best faculty for informatica in hyderabad ameerpet?
Explain scd type 3 through mapping.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is power center repository?
without matching columns in two tables. how can you join
How to generate the HTML output using Informatica.
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
How to update or delete the rows in a target, which do not have key fields?
can we see default group,when we use router?if yes how?
what is flat file override?
Teradata 
