1 Reply Latest reply on Jan 10, 2019 6:21 AM by Robert Whelan

    Create Rule to check duplicates

    Sina D New Member

      Hi All,


      I am using Informatica Analyst. I would like to create a Rule which checks for duplicate records but I need the rule to check on 3 concatenated columns.



      (UserID + ProductID + Segmentation)

      if there are more than 1 record for the combination above then its a duplicate.


      Can you please give me an idea what the rule syntax would look like?


      Hope it makes sense?


      Thanks in advance.