Vexdata.io Documentation
  • Vexdata Overview
  • Installation
    • System Requirements
    • Windows Installation
    • Linux Installation
    • Cloud Installation
      • GCP
      • Azure
      • AWS Cloud Deployment Architecture Diagram
        • Pre-requisites
        • Manual Install on ec2
        • Cloud Formation Scripts (command line)
    • Admin Post Installation Setup
    • User Post Installation Setup
    • Server Improvement (Optional)
  • Getting Started
    • Roles and Permissions
    • Managing Groups and Projects
      • Folders
      • Projects
    • Settings
      • Slack Integration
      • Integrations
      • Rules
      • Properties
      • Integrations
      • Email Template
      • Report Template
      • Create Data Connections
        • Databases/Warehouses
        • Run On
  • Creating and Executing Test Cases
    • Test Case
      • Create Test Cases
        • Define Data Source and Target
          • Configure Table/s from Database
          • Input SQL Data
          • Input Files
            • Excel/CSV
            • XML
            • JSON
            • Parquet/AVRO
          • API Input
          • Table Filter
          • Advance - Input
        • Data Compare
          • ETL Testing/Cell By Cell Compare
            • Data Compare Mapping
            • Data Compare Options
          • Schema Compare
          • Counts Compare
        • Schema Monitoring
        • Data Quality
          • SQL Rules
          • Column Level Rules
          • Duplicates
      • Executing Test Cases
      • Defining Test Case Settings
    • Test Runs
    • Variables
    • Note
    • Label
  • Reports
    • User Reports
    • Admin Report or Manager Reports
  • Current Limitations
Powered by GitBook
On this page
  1. Creating and Executing Test Cases
  2. Test Case
  3. Create Test Cases
  4. Data Compare

ETL Testing/Cell By Cell Compare

PreviousData CompareNextData Compare Mapping

Last updated 5 months ago

This compare option will compare the data, or columns, of the source and target tables on various checks.

To create a Cell By Cell Compare flow:

  • Drag a Source component from the palette to the canvas.

  • Choose the Input Source Configuration and select the tables to compare.

  • Drag a _Target _component from the palette to the canvas.

  • Choose the Input Source Configuration and select the tables to compare

  • Drag a Data Compare component and join the connections.

  • Select ETL Testing/Cell By Cell Comparison from the drop-down menu that appears at the bottom of the screen.

  • Select the primary key. By default, the primary key is selected for the tables. If the key is not selected, the system shows a warning sign for the user to select the Primary Key.

  • Save and execute the flow.

Vexdata can compare the selected source and destination tables to view:

  • Cell Level Validation Results.

  • Record Count Validations

  • Source and Destination key Distributions.

Data Compare Options
Cell By Cell Compare Tables Mapping
Cell by Cell Comparison Results Overview
Cell by Cell Comparison Stats