0 Replies Latest reply: Apr 13, 2012 8:11 PM by user10723402 RSS

    Group by


      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.

      Any help is greatly appreciated.