0 Replies Latest reply on Apr 14, 2012 1:11 AM by user10723402

    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.