(Glue-2011) Generate Variants

This functionality enables you to generate variants, based on one of the fields specified for selection in GLUE Extractor.

In case no field is marked for selection, you won't be able to use this generation functionality.

This generation is currently supported for extractors of types Standard DSO to Storage and SAP Table to Storage only.

To generate variants for GLUE extractor follow these steps:

  1. Go to (Glue-2011) Extractor Workbench
  2. Find your extractor in the tree structure, as shown in the picture below.
  3. Make sure your extractor's status is active. If the Extractor is active, you can see a green square right next to the technical name column of the extractor in the tree control.
     
  4. In the context menu choose Generate variants option.
  5. After this, the generator pop-up box will appear. You need to fill in all input fields:
    • Extractor name - Not editable, this is the extractor you are going to generate variants for.
    • Partitioning field - Field you are going to use for splitting data into variants
    • Variant name (prefix)  - Prefix for generated variants
    • Variant description (prefix) - Prefix for generated variants descriptions
    • Package size - Maximum number of rows transferred in one package during extraction
    • Variant limit - Number used as a limit, based on selected generation mode
    • Generation mode
      • Size-based (in MB) - When you select this option, the generation program approach to Variant limit as a number of megabytes. Then, based on Partitioning field the programs try to cover data that does not exceed 12 megabytes (number from the example image) of data per variant if it's possible. If not, the minimal possible value is selected.
      • Row-based - When you select this option, the generation program approach to Variant limit as to the number of rows. Then, based on Partitioning field the programs try to cover data that does not exceed 12 rows (number from the example image) of data per variant if it's possible. If not, the minimal possible value is selected.
      • Variant count - When you select this option, the generation program approach to Variant limit as the number of variants that need to be generated. Then, based on Partitioning field the programs try to split data into the desired number of a variant as evenly as possible. If it's not possible to generate the desired number of variant e.g., not enough distinct values are present in Partitioning field, the lower number of variants is generated but never more than the desired limit.
  6. Press Generate variant button to generate variants in background job or pres In Dialog to generate variants in the dialog.

    We recommend you to use Generate variant option generating variants in a background job because the selection of appropriate data portions might be time-consuming.

  7. After the job is successfully finished, press Refresh to rebuild the tree control. Your generated variants should be now visible.