Profile (or Sample) Your Data

To sample or profile the data in a specific project, first ensure that all the tables you want to sample are registered. After you register the tables, follow these steps:
tdm36
To sample or profile the data in a specific project, first ensure that all the tables you want to sample are registered. After you register the tables, follow these steps:
  1. Open the Datamaker UI and select
    Data Profiler, Sample Table Data
    from the main menu.
    The
    Perform Actions on Registered Objects
    dialog opens. The left pane represents the tree structure of the project. The middle pane contains a list of the registered objects within a project. 
  2. Select the table that you want to sample from the middle pane.
  3. Select
    Sample Data
    from the drop-down list in the top-right corner and click the forward arrow icon.
    The
    Sample Options
    dialog opens, allowing you to select the connection (Source, Target, or a Test Case).
  4. Enter appropriate information in the fields.
  5. Click 
    Build Scripts 
    and browse your directory for a batch file to build batch scripts, or click
    OK
    .
    Clicking
    OK
    displays the
    Data Sample
    dialog.
  6. Verify that all the requested tables are sampled. These tables are displayed in the tabs at the top of the dialog.
  7. (Optional) View the results as XML by selecting the XML icon in the bottom-right corner of the dialog.
    The
    Save as XML
    dialog opens. You can save these results to a CSV file or to the repository by clicking the relevant button in the XML dialog. You can also generate reports of the sample as CSV files by clicking the Generate reports icon.
  8. Select the columns that you want to work with by selecting the option that is associated with that column and clicking the tick mark icon.
  9. Select a sample type.

 
 
See also: