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
  • 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
      • 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
  • 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
          • LeapLogic Express
        • 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
        • LeapLogic Express
      • 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
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • 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 4.8) 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   »  Pipeline Reports   »  Reports and Insights   »  Transformation  »  On-premises to Cloud Transformation Report

On-premises to Cloud Transformation Report

This topic provides a comprehensive summary of the transformed scripts as well as a summary of all the statement types in the transformation stage. The Transformation stage contains two sections-Transformation and Assessment Report.

In this Topic:

  • Transformation
  • Assessment Report

Transformation

This stage provides the details of the logic and scripts that are transformed or not transformed into the target compactable scripts.

  • Total Scripts: Displays the number of scripts you have given as input in the transformation stage. It also gives a segregated view of how many scripts were successfully transformed and how many failed.
  • Status: Provides status of the Transformation stage.
  • Description: A brief description of the stage is displayed.
  • Total Queries: Display the total number of queries present in the scripts along with the number of parsed and unparsed queries.
  • Successfully Transformed Queries: Displays the number of queries that have been successfully transformed.
  • Automation Level Indicator: Displays the automation conversion coverage.
  • Auto-Validation: Displays the percentage of queries that have undergone syntax validation successfully.
  • User Feedback: Displays the auto conversion percentage based on your feedback.
  • Transformation Time: The time taken for transformation.
  • Validation Time: The time taken for validation.

The Transformation section contains three sub-sections. The sub-sections include:

  • Report
  • Package
  • Dependency

Report

This topic shows a comprehensive report of the converted artifacts. The left panel lists all the input files along with the file-wise transformation percentage. The right panel shows information about the selected file. It includes information about the original and transformed queries, transformation status, and more. In addition, if you perceive that a successfully converted query is inaccurate, then you can provide feedback and mark it as incorrect.

Click Mark as incorrect to show that the converted query is incorrect. Additionally, you can provide detailed feedback in the Add Comment field to explain the specific issues or discrepancies you have observed. After providing your constructive feedback, click  (Recalculate) to recalculate the automation conversion coverage based on your feedback. This ensures that the converted stage aligns more closely with the intended requirements or desired outcomes.

After clicking  (Recalculate), you can see the updated automation conversion coverage (User Feedback) based on your feedback in the Summary section.

When transforming legacy EDW workloads to Databricks Lakehouse, constraints such as primary key, foreign key, check, etc., present in the source data are transformed to Databricks-native equivalent if the Unity Catalog is enabled on the EDW Transformation configuration page. As depicted in the image below, original queries are converted to Databricks-equivalent code along with the constraints.

If the Utility Catalog is disabled on the EDW Transformation configuration page, the default Hive metastore is utilized. In such cases, legacy EDW workloads are converted to Databricks-equivalent code without any constraints.

On the EDW Transformation configuration page, if you have selected Databricks Lakehouse or Databricks Notebook as the target and uploaded the databricksrecommendation.csv report in the Databricks Recommendations Report field, the converted DDL queries will include liquid clustering details (clustered by column) mapped according to the Databricks Recommendations report (databricksrecommendation.csv). The image below shows a sample databricksrecommendation.csv report for reference.

For example, the below image shows the converted DDL queries with the liquid clustering (cluster by) details. As shown in the Databricks recommendations report (see above image), table New_employee has three cluster by columns (ASSOCIATED_ID, ASSOCIATED_NAME, DOB) and all of them are mapped in the converted query.

If you have not uploaded the Databricks recommendations report in the Databricks Recommendations Report field while configuring the EDW Transformation stage, then you won’t be able to get the liquid clustering (cluster by) details on the converted DDL queries.

In addition, you can also take a variety of actions, including:

Feature Icon Description
Query Recommendation
To get instant recommendations for improving the performance of the queries based on best practices for query construction. To apply Query Recommendations, choose:
  • Apply All: To apply query recommendations to all the queries.
  • Custom Selection: Specify the queries to apply query recommendations. To do so,
    • Click Custom Selection.
    • Select the queries by checking the check boxes of respective queries.
    • Click to get the recommendation for query optimization.



      If the recommendations for query optimization are carried out successfully, the system generates a snackbar popup to notify the success.

Download Download the transformed artifacts (sh scripts, java files, etc.), validation report, and executable jar file as a zip.
Regenerate
Edit the transformed queries using the notebook-based online editor. Update and repackage your code after making the necessary changes to apply the updated query. The Regenerate feature helps to update and repackage your query in the Transformation stage.
If the artifacts are updated successfully, the system generates a snackbar popup to notify the success.

Create Pipeline The transformed code can be reformed into a visual pipeline on the Stream Analytic platform where the transformed code can be orchestrated and executed effortlessly.
Update
To upload the updated query files to replace the manually corrected queries:
  • Click .
  • Upload the updated query file (.xlsx or .xls file) in the Update field to replace the auto-transformed queries with the manually corrected queries.
  • Enable Includes Header toggle if the first row contains column names in the uploaded files.

Validate To validate the replaced queries.
Compare
Line-by-line comparison of the transformed queries and the source queries to identify the changes.

Edit
To manually edit failed queries using the Notebook-based online editor. Furthermore, you can repackage the updated code with the Regenerated option. To do so,
  • Click .
  • Make the necessary changes in the transformed queries.
  • Click to update the queries.

Sort
To sort the queries. You can sort the queries based on:
  • All Queries
  • Success Queries
  • Failed Queries
  • Manually Corrected
  • Recommendation: Yes
  • Recommendation: No
 
Filter To filter the queries based on the query type.
View Notebook
To manually edit failed queries using the Notebook-based online editor. Furthermore, you can repackage the updated code with the Regenerated option. To do so,
  • Click .
  • Make the necessary changes in the transformed queries.
  • Click to update the queries.

Warning

The generated artifacts would be failed during execution because of compilation issues.

Package

This section provides a detailed report of the converted artifacts containing python files, sql files, etc. along with an executable jar file.

In the converted artifacts, you can see a detailed error specifications associated with the transformations, offering insights to enhance visibility and improve troubleshooting efficiency. To effectively diagnose and track issues, we provide detailed information in the following message formats: Info, Error, Warning, ToDo, and Alert.

To see a comprehensive guidance on error specifications and troubleshooting, refer Error Specifications & Troubleshooting.

Additionally, in the Package section you can see Transformation_Report.xlsx file which contains a comprehensive report of the transformation, and the associated deductible license quota. License quota is deducted for units when converting EDW workloads such as Teradata, Oracle, etc., to target equivalents, where unit refers to query in the workload. The license deduction logic is determined based on File similarity and Complexity. 

File similarity – File similarity checks whether the source file is related or similar to an already executed file. A higher file similarity value indicates that you already executed a similar file. The license quota deduction depends on whether the file similarity value falls below the predefined threshold. Specifically, if the file similarity value is below the threshold, then the system will deduct the license quota. Conversely, if the file similarity value exceeds the threshold, it won’t incur any license quota deduction, indicating that the file has been processed before. For instance,

  • If the file similarity value is 70% (below the threshold) and the threshold is 80%, then the system deducts the unit quota.
  • If the file similarity value is 92% (above the threshold) and the threshold is 80%, then the system will not deduct unit quota.

Complexity – One of the criteria to determine the license quota deduction is based on the complexity of each unit. The unit complexity is categorized into SIMPLE, MEDIUM, and COMPLEX. The complexity weightage for the deductible unit quota is outlined as follows:

  • If the unit complexity is SIMPLE, the deductible unit quota is 1.
  • If the unit complexity is MEDIUM, the deductible unit quota is 3.
  • If the unit complexity is COMPLEX the deductible unit quota is 5.

For instance, consider the example provided in the image below for the file Teradata_DML.sql. This file contains a total of 10 units, all of which are successfully transformed. Among these successfully transformed units:

  • 8 units are categorized as Simple complexity with a weightage of 1. Consequently, the deductible unit quota for these units is 8.
  • 1 unit is categorized as Medium complexity with a weightage of 3. Consequently, the deductible unit quota for these units is 3.
  • 1 unit is categorized as having Complex complexity with a weightage of 5. Consequently, the deductible unit quota for these units is 5.

So, the total deductible unit quota for Teradata_DML.sql file is 16.

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 each script.
  • 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. If the file is similar to the already executed file, then the Deducted Script Quota and Deducted Unit Quota will be zero and will not deduct any quota.
  • 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 of each successfully transformed unit.
  • Deducted Unit Quota: Displays the actual unit quota deducted from license.

The Query Summary sheet provides information about the queries along with 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.
  • Procedure Name: Displays the name of the procedure.
  • Procedure Parameters: Displays the number of parameters in each procedure.
  • Original Query: Displays the original query.
  • Query Type: Displays the query type.
  • Auto Generated Query: Displays the auto-generated query.
  • 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.
  • Complexity: Displays the query complexity.
  • Deductible Quota: Displays the quota that needs to be deducted based on the complexity of each successfully transformed query.
  • Deducted Quota: Displays the actual unit quota deducted from the license.
  • UDF Used: Displays the user-defined functions used in each query.
  • 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.
  • Manually Corrected: Indicates whether the query needs manual intervention.
  • Manual Query: Displays manually updated queries.
  • Transformation Discrepancy: This indicates whether there is a difference between the source and target query constructs. If the value is Yes, it signifies that there is a discrepancy between the source and target query constructs. For instance, if the source query has one join condition, but the target or converted query has two which highlights a discrepancy. Conversely, if the value is No, it signifies that there is no difference in the query construct between the source and target queries.
  • 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.
  • Query Construct: Displays the number of source and target query constructs such as Joins, sub-queries, and conditions.

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.”

You can apply:

Feature Icon Description
Compare
Line-by-line comparison of the transformed queries and the source queries to identify the changes.

Edit
To manually edit queries using the Notebook-based online editor. Furthermore, you can repackage the updated code with the Regenerated option. To do so,
 
  • Click .
  • Make necessary changes in the transformed queries.
  • Click to update the queries.

Note:

If the uploaded DML files specify parameterization of the database name as placeholders in the property files, it supports declaring and handling variables in the generated file. As a result, rather than the database name, the placeholder’s name is displayed in the query.

Dependency

It illustrates the complex interdependencies between various enterprise workloads through a process lineage graph. Whenever one database is dependent upon another, or when one table is dependent upon another, to demonstrate this relationship, lineage or dependency graphs are generated.


Assessment Report

This section displays a summary of all the statement types in the transformation stage. It presents details about the total statement type, various types of statements used in queries, the count of a particular statement type, and the auto-converted queries.

You can download the Transformation report based on the different statement types used in the queries. To download the report, click the .


    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 ↑