Test Data Manager

Hi Team,

  I am trying to generate data for volume testing, how can i make sequence continuation with first and second runs.

  For example in first run i have generated 1 to 1000 sequence id's and in next run it should continue from 1001. Can you please suggest how can i achieve this.

Thanks

Hi Gaurav,

You could create a sequence on the database and then use it in TDM using the function below to get the next value.

@nextval(sequence_name)@

You should set the sequence to start from 1 and increment by 1. The sequence will continue from where you left off each time you invoke the function.

Thanks,

Anil 

Hi Anil,

Thanks for you reply, In my case the db is in client environment where I shouldnt touch the db.Can we do it something from CA data maker tool?

Thanks,

Satish.

Hi Anil,

Sorry i missed to add one more, Here sequence what i am referring is not db sequence for example if i had a db column ID where their values are in sequence like A0001,A0002,A0003.....and so on, So in my first run the sequence is till A1000 then in second run my sequence has to start from A1001.

Thanks

Gaurav,

You can create a sequence on the TDM repository database which you should have access to and need not be created on the client database. To achieve the sequence you need use a combination of functions along with the sequence like the below:

A@leftpad(@nextval(sequence_name)@,0,4)@

Thanks,

Anil