(GLUE-1905) 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-1905) Extractor Workbench
  2. Find your extractor in tree structure, show in following image.
  3. Make sure your extractor has status active. If extractor is active, you can see green square right to technical name column of the extractor in the tree control.
     
  4. Right click on Generate variants option.
  5. After the click, the generator pop-up will appear. You need to fill all input fields:
    • Extractor name - Not editable, this is 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 transfered in one package during extraction
    • Variant limit - Number used as 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 number of megabytes. Then, based on Partitioning field the programs tries to cover data that does not exceed 12 megabytes (number from 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 number of rows. Then, based on Partitioning field the programs tries to cover data that does not exceed 12 rows (number from 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 number of variants that needs to be generated. Then, based on Partitioning field the programs tries to split data into desired number of variant as evenly as possible. In it is not possible to generate desired number of variant e.g. not enough distinct values are present in Partitioning field, the lesser number of variant is generated but never more than desired limit.
  6. Press Generate variant button to generate variants in background job or pres In Dialog to generate variants in dialog.

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

  7. After job is successfully finished, press Refresh to rebuild tree control. It should now show also your generated variants.