Hi Satish,
In Fast Data Masker (FDM), there is no functionality to be able to specify a custom start value for a sequence using the NEXTVAL function. Every time the function is used in the masking process, the current sequence value will be incremented by 1, and the record updated with that value.
What you could do as a workaround is use SQL statements to manually set the sequence to a specific value 'X' as part of a PRESTEP option in FDM. The masking process will then mask the first record with value 'X+1', and so on. A brief description of the Prestep option is given here: Masking Options - CA Test Data Manager - 3.8 - CA Technologies Documentation
If you wish to have the functionality of specifying a start value for the sequence, please submit an enhancement request by creating an 'Idea' on the TDM Community page here:
(Content -> (Actions) -> Create an Idea)
Please also include the business need for this enhancement, how soon you would need it, and the potential business impact if it is not provided.
You and other community users will be able to 'vote' for this enhancement request. It will be reviewed by product managers at frequent intervals who will decide if the enhancement will be added to the product and when. You will be notified of the enhancement request's progress by the Idea post being marked as 'Under Review', 'Currently Planned' , or 'Delivered' by CA.
Thanks,
Sameer