Edit Data Creation Functions

CA TDM provides a series of data creation functions that you can edit and test.
CA TDM provides a series of data creation functions that you can edit and test.
  1. Open the Datamaker UI and select
    Projects, Project Manager
    from the main menu.
  2. Navigate the hierarchy in the left pane until you find the required data pool.
  3. Double-click the selected data pool.
    Data Definition
    dialog opens.
  4. Double-click the table in the left pane.
    The table opens in a tab in the right pane.
  5. Double-click in a column.
    View/Edit data in column
    dialog opens. 
  6. Use this dialog to edit and test the data functions. The dialog allows you to click on objects in each of the three panes. These objects transfer to the edit section where they are manipulated. The three sections are as follows:
    Expressions in this window have a limit of 16000 characters.
    • Functions
      Functions can use hard-coded values, columns, or variables as parameters. Functions can also use other functions as parameters. For example, you can use a function as a result from a Boolean operator in the IF function.
    • Columns
      The columns list contains any other columns in the table or other tables. Click the
      Other Tables
      option to expand the list of columns from other tables.
    • Variables
      The variables column contains a mixture of system operators (prefixed with a star) and any substitution variables you have created.
  7. Click the help on functions icon to find more information about the list of available data editing functions. Some common features to these functions are as follows:
    • Percnull
      This function allows you to identify the percentage of rows that are null. Selecting 20 means 20 percent of the values are designated null.
    • Sources
      The valid values are R = Repository, S = Source, T = Target. When this function is run, it accesses the database connection to run the appropriate SQL. For example, seqlov(0,S) looks for a sequential list of values based on your SOURCE connection.
    • Sources (LoV)
      In the
      List of Values options
      dialog, you see that each source of value has an identifier, marked from A to J.
      You can include these values in any of the data sources. Therefore, randlov(0,DG) produces a random list of values using the invalid values and values used in the data source.
  8. Review and save your changes.
You can select the first row value for the column by including (1) after the column name. For example, ASSIGNED_SEAT(1) provides the value of the first row. You can use the value of a previous row by adding (-1). This approach is useful if you want to sum a value through the rows. For example, in the column CUR_AMT, set the function to @SUM(cur_amt,transaction_amt(-1))@. This function adds the value of transaction_amt from the previous row to the cur_val column.