Generate Data Definition Expressions for Cloning and Subsetting

In a dataset, create an empty data pool in which you generate your data definition expressions. Provide a subset extract that defines table relationships, and use the information on these relationships to create expressions in table definitions. These complex expressions are generated automatically by the Data Creation Assistant to allow Datamaker to clone or subset data from source to the target.
tdm38
In a dataset, create an empty data pool in which you generate your data definition expressions. Provide a subset extract that defines table relationships, and use the information on these relationships to create expressions in table definitions. These complex expressions are generated automatically by the Data Creation Assistant to allow Datamaker to clone or subset data from source to the target.
  1. In Datamaker, click Settings, Enable Data Creation Assistant.
  2. Right-click and edit the datapool. The data creation assistant window opens.
  3. Choose Subset Data and select your extract.
  4. Click Create Data Based on Subset.
  5. Choose one of the following Subset Conditions and click the tickmark:
    • Exists Select
    • Inner Join Select
  6. Review the row population rules for this condition and click the tickmark to confirm. The Data Definition Row Editor opens.
The table is populated with expressions that correspond to the subset extract used.