Test Data Manager

Expand all | Collapse all

Synthetic Test data Creation Functions

Jump to Best Answer
  • 1.  Synthetic Test data Creation Functions

    Posted 11-10-2016 03:51 AM

    Hi All, 

    i am looking for following functions in Data Maker 

    1) random Decimal number with decimal precision

    2) casting functions from one data type to other 

    3) formatting functions for Date, date time or time stamp.

     

    Please help me if we have any such functions. 



  • 2.  Re: Synthetic Test data Creation Functions
    Best Answer

    Posted 11-11-2016 03:28 PM

    Hi Raju,

     

    There are multiple ways of generating what you are looking for. These are just examples.

    For more information on these functions, please refer to the documentation at:

    Data Generation Functions and Parameters - CA Test Data Manager - 3.8 - CA Technologies Documentation 

     

    1) random Decimal number with decimal precision

    You could use something like @randrange(2,300)@.@randrange(2,40)@

    You may also use the STRING(NUMBER, NUMBERFORMAT) function. For example, @string(@randrange(1,30000)@,0.00)@

     

    2) casting functions from one data type to other

    Typically, Datamaker will take care of casting functions to the appropriate data type (depending on the data type of the column). If you do face issues however, please open a support case.

     

    3) formatting functions for Date, date time or time stamp.

    You may use string(date,dateformat) which will return the date in a specific "dateformat". For example,

    @string(~CDATE~, YYYY-MM-DD)@

     

    Please review the documentation. If you feel there is a function that is missing and you would like added to the product, please submit an idea on the communities under category "CA Test Data Manager" and provide examples and business need. Product Management will then review it and make a decision on whether it could be added to an upcoming release.

     

    Thanks,

    Sameer 

     



  • 3.  Re: Synthetic Test data Creation Functions

    Posted 11-12-2016 03:53 AM

    Thanks Sameer.