Home »
License » ETL Conversion – License Deduction Criteria
ETL Conversion – License Deduction Criteria
This topic provides information about the license deduction criteria used in LeapLogic to transform legacy EDW workloads to a modern cloud platform equivalent.
In This Topic:
License Deduction Criteria
When you transform EDW workloads such as Teradata, Oracle, etc., to their target equivalents, the unit license quota is deducted. Here, a unit refers to a query in the workload that is successfully transformed. The license deduction logic is determined based on the following criteria:
- File Similarity
- Complexity
- Automation Level Indicator
- Number of Successfully Transformed ETL Scripts
Here is a detailed explanation of each criterion:
File Similarity
The platform employs a similarity evaluation framework that determines the relative correspondence of an incoming file against a corpus of previously processed artifacts. This evaluation yields a similarity index which, in turn, is reconciled with internally governed threshold parameters. The interaction between these values serves as the basis for deciding whether an adjustment to the license quota becomes applicable. In certain conditions—when the index exhibits sufficient divergence or proximity to the threshold—quota units may be appropriated, while under alternative conditions, no adjustment is applied.
Accordingly, files demonstrating pronounced affinity to earlier executions may, under some circumstances, bypass incremental quota attribution, whereas those exhibiting less congruence may result in measurable deductions. The precise determination is mediated by proprietary system logic, operating on layered interpretations of similarity scores.
Complexity
Beyond similarity considerations, the dimensional aspect of unit-level complexity exerts a significant influence on how quota utilization is ultimately reconciled. Each transformation embedded within a workflow undergoes an internalized evaluation process, wherein its relative intricacy is algorithmically weighted. The categories conventionally denoted as Simple, Medium, and Complex are best regarded as heuristic markers rather than rigid determinants, serving to indicate how the platform apportions value within the broader license framework.
Quota adjustments therefore emerge not as a straightforward arithmetic application but as the aggregated outcome of weighted interpretations distributed across all constituent units. As a result, even workflows of ostensibly comparable scale may reflect markedly different quota implications, contingent upon how the system adjudicates and interprets the relative complexity of their internal transformations. In effect, the quota impact is shaped less by file size alone than by the nuanced interplay of classification, weighting, and systemic evaluation.
Automation Level Indicator
Automation Level Indicator refers to the extent to which files are automatically converted from source to the target equivalent. Higher automation level indicator value indicates that most of the file is automatically converted and requires less manual intervention. The license quota deduction depends on whether the automation level indicator meets or exceeds the predefined threshold value.
Number of Successfully Transformed ETL Scripts
This is one of the criteria used for license quota deduction, where the deduction depends on the number of successfully transformed ETL Scripts.
View Transformation Quota Details
Follow these steps to see detailed license information:
- Click your username at the top right corner of the screen.
- Click License from the menu.
- The Manage Licenses window opens. Click View Details to see detailed license information.
- The License Details page opens. This page provides comprehensive information about your licensing status, quota consumption, activated licenses, upcoming licenses, and a history of expired licenses. You can also monitor the granted licenses and LeapLogic service usages from this page.
For more information about your license, click here.
ETL Transformation Report
The Transformation Report provides a comprehensive summary of the ETL transformation along with the associated deductible license quota.
Taking Informatica as an example, the license quota is deducted for units when converting workloads to target equivalents, where each unit refers to transformation. You can view the transformation report for Informatica below.
The Summary sheet (refer the above image) in Transformation_Report.xlsx file showcases detailed information about the license deductible quota.
- File Name: Displays the name of the file.
- Folder Name: Displays the name of the folder.
- Workflow: Displays the name of the workflow.
- Automation Level Indicator: Displays the auto-conversion percentage of each workflow.
- File Similarity: Indicates whether the file is similar to the already executed file. If the value is Yes, then the file is similar to an already executed file else No.
- Complexity: Displays the complexity of each workflow.
- Total Transformation: Displays the number of total transformations.
- Success Transformation: Displays the number of successfully transformed transformations.
- Deductible Units: Displays the unit quota that needs to be deducted based on the complexity checks and balances.
- Deducted Unit Quota: Displays the actual unit quota deducted.
The Query sheet provides information about all queries along with its conversion status, transformation engine, validation status, and more.
- File Name: Displays the name of the file.
- Folder_Name: Displays the name of the folder.
- Workflow: Displays the name of the workflow.
- Mappings: Displays the associated mappings.
- Transformation name: Displays the name of the transformation.
- Transformation type: Displays the type of transformation.
- Query: Displays the source query.
- Query Status: Displays the status of the query validation. If the status is SUCCESS, it indicates the query passed syntax validation, FAILED indicates a validation failure, and N/A indicates syntax validation is not applied.
- Error message: Shows the reason for query validation failure.
- Conversion Status: Displays the conversion status of each query. If the conversion status is SUCCESS, it signifies that the query has been successfully transformed to the target equivalent whereas the FAILED status indicates that the query is failed to transform.
- Conversion Engine: Displays the conversion engine used to transform each query. If the LeapLogic Transformation Engine fails to convert queries to the target equivalent, then the system will convert failed queries to the target equivalent based on the transformation model selected on the configuration page.
- Query id: Displays the query id.
The Translation_Report sheet in Transformation_Report.xlsx file provides a comprehensive report of the conversion. It includes information about workflows, mapplets, mappings, transformations, and more.
- File Name: Displays the name of the file.
- Folder_Name: Displays the name of the folder.
- Workflow: Displays the name of the workflow.
- Mapplet: Displays the name of the mapplet.
- Mappings: Displays the associated mappings.
- Transformation: Displays the associated transformation.
- Transformation_Name: Displays the name of the transformation.
- Used_By_Workflow: Displays the associated workflow.
- Target_File_Name: Displays the name of the target file.
- Function_Name: Displays the function associated with the transformation.
- Status: Indicates the conversion status of each function. If the value is SUCCESS the function is converted successfully, else FAIL.
The Transformation_License_Report sheet provides a comprehensive report of the conversion along with the unit quota deduction.
- File Name: Displays the name of the file.
- Folder_Name: Displays the name of the folder.
- Workflow: Displays the name of the workflow.
- Mappings: Displays the associated mappings.
- Type: Displays the type of each workflow.
- Transformation_Name: Displays the associated transformation.
- TRANSFORMATION_TYPE: Displays the type of the transformation.
- Conversion Status: Indicates the conversion status of each transformation. If the value is SUCCESS the transformation is converted successfully, else FAIL.
- Automation Level Indicator: Displays the automation conversion percentage of each transformation.
- Complexity: Displays the complexity of each transformation.
- Deductible Units: Displays the unit quota that needs to be deducted based on the complexity checks and balances.
- Deductible Query Units: Displays the EDW query units that need to be deducted based on the number of transformed queries.
- Total Deductible Units: Displays the total number of deductible unit quota and EDW query units.
- Deducted Unit: Displays the actual unit quota deducted.