I have the input data as below and at the Database the key column is a Sequence.
Pick the Max value and assign the sequence.
As far i know we can get the max value using SQL lookup or set properties, want to ensure how this works for Sequence..
Columns in CUST Table:
CUST_ID - SEQUENCE