I have four columns in my target table: emp_seq_id, emp_id, emp_grp,emp_type. Emp_seq_id is populated by a sequence value. But I need to increment this sequence only when count of the other threee columns is greater than 1000. How can I implement this in ODI interface/procedure?
When I group by emp_grp, emp_type and emp_id and for the first 1000 records the emp_seq_id should be 1, and for the next 1000 records the emp_seq_id should be incremented by 1 and so on.