Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • LeapLogic Deployment Architecture & Prerequisites
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Shell
        • Highlights
        • Analysis
        • Lineage
        • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Script/ Query Log/ Code Extraction Prerequisites
    • Cloud
      • Azure Data Factory
      • Snowflake
      • Azure Synapse
      • Google BigQuery
      • Redshift
      • Azure SQL Database Hyperscale
      • Aurora PostgreSQL
    • EDW
      • Oracle
      • Netezza
      • Teradata
      • Vertica
      • SQL Server
      • Db2
      • MySQL
      • PostgreSQL
    • ETL
      • DataStage
      • Informatica
      • SSIS
      • Talend
      • ODI
      • IICS
      • DBT
      • Pentaho
      • Matillion
      • SnapLogic
      • Ab Initio
      • SAP BODS
      • TAC
      • WebFOCUS
    • BI
      • IBM Cognos
      • OBIEE
      • Tableau
      • Metabase
      • MicroStrategy
      • PowerBI
      • LeapLogic Utility for SAP BO
      • SAP BO Universe and Web Intelligence
      • SSRS
    • Analytics
      • SAS
      • Alteryx
    • Orchestration
      • AutoSys
      • Control-M
      • SQL Server
    • Mainframe
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
            • Assigning Roles
            • Intelligent Modernization
          • LeapFusion
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Manage Quota
    • Product Usage Metrics
  • License
    • Workload Assessment
    • EDW Conversion
    • ETL Conversion
    • BI Conversion
    • Orchestration Conversion
    • Data Migration
    • Data Validation
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 5.0) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  License  »  EDW License Deduction Criteria

EDW 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
  • View Transformation Quota Details
  • EDW Transformation Report


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 Workloads

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 Workloads

This is one of the criteria used for license quota deduction, where the deduction depends on the number of successfully transformed workloads.



View Transformation Quota Details

Follow these steps to see detailed license information:

  1. Click your username at the top right corner of the screen.
  2. Click License from the menu.
  1. The Manage Licenses window opens. Click View Details to see detailed license information.
  1. 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.


EDW Transformation Report

The Transformation Report provides a comprehensive summary of the transformation along with the associated deductible license quota.

The Summary sheet (refer above image) in Transformation_Report.xlsx file showcases detailed information about the license deductible quota.

  • File Name: Displays the name of the file.
  • Automation Level Indicator: Displays the auto-conversion percentage of scripts.
  • 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.
  • Script Complexity: Displays the complexity of each file.
  • Total Blocks: Displays the total number of blocks.
  • Success Blocks: Displays the number of successfully transformed blocks.
  • Total Units: Displays the total number of units.
  • Success Units: Displays the number of successfully transformed units.
  • Deductible Unit Quota: 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 from license.

The Query Summary sheet provides information about the queries along with the count of total, auto-converted, and manually corrected queries.

  • Statement: Displays the statement types.
  • Total Count: Displays the number of queries for each statement type.
  • Auto-Converted Count: Displays the number of queries that are automatically converted for each statement type.
  • Manually Converted Count: Displays the number of queries that require manual intervention for each statement type.

The Transformation Report sheet lists all the queries along with their type, auto generated query, status, complexity and more.

  • File Name: Displays the name of the file.
  • Original Query: Displays the original query.
  • Query Type: Displays the query type.
  • Auto Generated Query: Displays the auto-generated query.
  • Complexity: Displays the query complexity.
  • UDF Used: Displays the user-defined functions used in each query.
  • Optimization Status: Indicates whether the transformed query is optimized for better performance and efficiency.
    • If the Optimization Status is Optimized, the query is optimized for the target environment.
    • If the Optimization Status is Not Applicable, the query is not applicable for optimization.
  • Optimization Details: Describes the optimization techniques applied to enhance query performance.
  • Changed Model Applied: Provides information on any applied changes to the model. It is a mapping between source and target tables as well as columns along with a definition of the mapping condition such as Inner Join, etc.
  • Procedure Name: Displays the name of the procedure.
  • Procedure Parameters: Displays the number of parameters in each procedure.
  • Status: Indicates the conversion status of each query. If the value is SUCCESS the query is converted successfully, else FAILED.
  • Validation Status: Displays the status of query validation.
  • Script Line: Displays the number of lines present in each query/ procedure.
  • Script Column: Displays the number of columns that are used in the query.
  • Error Message: Shows a brief message of auto-conversion or query validation failure.
  • Error Details: Shows a detailed message of auto-conversion or query validation failure.
  • Deductible Quota: Displays the unit quota that needs to be deducted based on the complexity checks and balances.
  • Deducted Quota: Displays the actual unit quota deducted from the license.
  • Manually Corrected: Indicates whether the query needs manual intervention.
  • Manual Query: Displays manually updated queries.
  • Conversion Engine: Displays the name of the engine that transforms the original query into the target-equivalent query.
  • Marked Incorrect: Indicates whether you have marked the converted query as incorrect or correct. To populate this column values:
    • Select the Mark as incorrect or Mark as correct option available in the Transformed Query (under Reports section in the Transformation report). For example, flag a successfully transformed query as incorrect or flag a failed query as correct.
    • Provide detailed feedback in the Add Comment field explaining the specific issues or discrepancies.
    • Click the Regenerate icon to regenerate the transformation artifacts and repackage them in the Transformation stage.
    • The Marked Incorrect and Feedback columns in the transformation report will display the updated details.

    • The Marked Incorrect column displays the following values:

      • N/A: Displays by default when you execute the pipeline or when no query has been marked as incorrect/ correct.
      • Yes: Indicates that the converted query has been marked as incorrect/ correct.
      • No: Indicates that the query was previously marked as incorrect/ correct, but the feedback has been reverted.
  • Feedback: Displays the feedback provided in the Add Comment field in the Transformed Query (under Reports section in the Transformation report). By default, it displays N/A when you execute the pipeline, or no feedback has been added.

When you try to convert units that exceed the available license quota, those within the quota will successfully convert. However, any additional units beyond the quota will fail to transform and display an error message indicating “License quota insufficient.”


To learn more, contact our support team or write to: info@leaplogic.io

Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

  • Terms of Use
  • Privacy Policy
  • License Agreement
To the top ↑ Up ↑