(Glue-2005) Generate Variants

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

To generate variants for GLUE extractor follow these steps:

1. Go to (Glue-2005) 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 extractor is active, you can see green square right next to technical name column of the extractor in the tree control.
    
4. Right-click on Generate variants option.
   
5. After this click, 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 number of megabytes. Then, based on Partitioning field the programs tries 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 number of rows. Then, based on Partitioning field the programs tries 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 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. If it's not possible to generate desired number of variant e.g. not enough distinct values are present in Partitioning field, the lower 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 the job is successfully finished, press Refresh to rebuild the tree control. Your generated variants should be now visible.