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.
A Rule must be passive, i.e. it cannot modify the number of rows or the order in which the rows are received. As matching between records requires comparison between rows I don't think the logic available in the Analyst will be broad enough so you will need to use the Developer.