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.

       

      E.g.

      (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.