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   »  Workload Assessment   »  Understanding Insights and Recommendations  »  Volumetric Info

Volumetric Info

This topic provides detailed information about the generated volumetric info sheet. The volumetric info sheet summarizes the aggregated inventory after analyzing the source files. For instance, if the source is EDW, it includes information about the total number of DML and DDL scripts, entities, queries, procedures, lines of code, and a lot more.

In This Topic:

  • EDW
  • ETL
  • Orchestration
  • BI
  • Analytics



EDW

The following table displays a brief summary on Volumetric Info and Complexity reports of various EDW sources such as Teradata, Oracle, etc.

Source Folder Name Report Name Sheet Name Column Name Extensive Reports
Oracle Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Teradata Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Insights and Recommendations Procedure.xlsx Volumetric Info Inventory Details
Insights and Recommendations Procedure.xlsx Macros/ Packages Procedures Functions/ SQLs/ Package Cursor Queries Complexity
Insights and Recommendations Procedure.xlsx Complexity Summary SQL Complexity 1/ Functions Complexity 1/ Procedures Complexity 1
SQL Server Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Vertica Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Netezza Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Snowflake Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Azure Synapse Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Google BigQuery Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity
Redshift Source Inventory Analysis Analysis Report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Analysis Report.xlsx Query Complexity Wise Query Count Query Complexity



ETL

The following table displays a brief summary on Volumetric Info and Complexity reports of various ETL sources such as Informatica, Ab Initio, DataStage, etc.

Source Folder Name Report Name Sheet Name Column Name Extensive Reports
Informatica Insights and Recommendations Informatica Assessment.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Informatica Assessment.xlsx Workflow Summary Complexity
DataStage Insights and Recommendations DataStage Assessment.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations DataStage Assessment.xlsx Job Summary Complexity
Ab Initio Insights and Recommendations AbinitioCustomComplexityReport.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations AbinitioCustomComplexityReport.xlsx Abinitio Complexity Complexity
SSIS Insights and Recommendations SSIS Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations SSIS Report.xlsx File Summary Complexity Level
Oracle Data Integrator Insights and Recommendations ODI Assessment.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations ODI Assessment.xlsx Procedure Details Complexity
Insights and Recommendations ODI Assessment.xlsx Mapping Details Complexity
Pentaho Insights and Recommendations Pentaho_Assessment_Complete_Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Pentaho_Assessment_Complete_Report.xlsx Job Summary Complexity Category
SnapLogic Insights and Recommendations Snaplogic Assessment Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Snaplogic Assessment Report.xlsx Pipeline Summary Complexity
Talend Insights and Recommendations Talend Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Talend Report.xlsx Job Summary COMPLEXITY
Informatica BDM Insights and Recommendations InformaticaBDMSummary.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations InformaticaBDMSummary.xlsx Mapping Summary, Workflow Summary Complexity
Azure Data Factory Insights and Recommendations ADF Assessment Report.xlsx Volumetric Info Type Other insightful reports
Insights and Recommendations ADF Assessment Report.xlsx Pipeline Summary Complexity
Matillion Insights and Recommendations Matillion_Assessment.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Matillion_Assessment.xlsx Job Level Assessment Complexity


Orchestration

The following table displays a brief summary on Volumetric Info and Complexity reports of various Orchestration jobs such as AutoSys, Control-M and SQL Server.

Source Folder Name Report Name Sheet Name Column Name Extensive Reports
AutoSys Insights and Recommendations AutoSys_Assessment_Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations AutoSys_Assessment_Report.xlsx Box Summary, Job Summary Complexity
Control-M Insights and Recommendations control_m_job_summary.csv control_m_job_summary TotalJobsCount Other insightful reports
SQL Server Insights and Recommendations jobs_information.csv jobs_information job_name Other insightful reports


BI

The following table displays a brief summary on Volumetric Info and Complexity reports of various BI reports such as OBIEE, IBM Cognos, Tableau, etc.

Source Folder Name Report Name Sheet Name Column Name Extensive Reports
OBIEE Source Inventory Analysis Obiee_report.xlsx Volumetric Info Inventory Details Other insightful reports
Source Inventory Analysis Obiee_report.xlsx Report Summary Sheet Complexity Category
Tableau Insights and Recommendations Tableau Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations Tableau Report.xlsx Summary Complexity
IBM Cognos Insights and Recommendations Cognos Assessment Report.xlsx Volumetric Info Report Detail Other insightful reports
Insights and Recommendations Cognos Assessment Report.xlsx Report Overview Complexity
MicroStrategy Insights and Recommendations MSTR Assessment.xlsx Volumetric Info Volumetric Details Other insightful reports
Insights and Recommendations MSTR_COMPLEXITY.xlsx DataSet_Complexity, Visual_Complexity complexity
Power BI Insights and Recommendations PowerBi Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations PowerBi Report.xlsx DataSet Summary, Visual Summary Complexity
SSRS Insights and Recommendations SSRS Report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations SSRS Report.xlsx Visual Summary Complexity
SAP BO Insights and Recommendations SAP_BO_Crystal_Report_Assessment.xlsx Volumetric Info Total Reports Other insightful reports
Insights and Recommendations SAP_BO_Crystal_Report_Assessment.xlsx DataModel Summary Complexity


Analytics

The following table displays a brief summary on Volumetric Info and Complexity reports of various Analytics sources such as SAS and Alteryx.

Source Folder Name Report Name Sheet Name Column Name Extensive Reports
SAS Insights and Recommendations SAS Code Assessment.xlsx Summary Summary Other insightful reports
Insights and Recommendations SAS Code Assessment.xlsx Complexity Measures Complexity
Alteryx Insights and Recommendations alteryx_report.xlsx Volumetric Info Inventory Details Other insightful reports
Insights and Recommendations alteryx_report.xlsx Workflow Summary complexity


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 ↑