# Create Compare Job

Compare jobs validate and identify differences between two data sources.

## Step 1: Job Type Selection

* Select **Job Type** as **Compare**.
* Enter a **Description** for the job.
* Click **Next**.

![Select Job Type](/files/MnglFSsaFCcnQWetRzGe)

## Step 2: Connection Configuration

1. Select the **Source Data Source Connector** from the dropdown.
2. Enter the required **Configuration Details** for the Source.
3. Click **Verify** to test the connection.
4. Select the **Target Data Source Connector** from the dropdown.
5. Enter the required **Configuration Details** for the Target.
6. Click **Verify** to test the connection.
7. Once both connections are verified successfully, click **Next**.

![Source Configuration](/files/BmLVXNe6GEXc8kZX23kM) ![Target Configuration](/files/BFN3ps8cLQebmiHj1p3n)

## Step 3: Column Code Transformation & Column Mapping

### Column Code Transformation

Apply column-level transformations to source and target data before comparison.

1. **Save** the job first.
2. Create the required **functions** for this job. [Create Fucntions](/data-testing/functions-and-transformations/index/creating-functions.md)
3. Reopen the job in **Edit Mode**.
4. Click **Fetch** to load available functions.
5. Select and apply the desired transformation functions.

![Apply Column Transformations](/files/YcyEDNQWd3FTFk3qj7lA)

### Column Mapping

Column mapping is required when source and target have different column names but represent the same data.

**Example:** Source `transaction_id` maps to target `transaction_number`.

* Map columns in the **Mapping Table** by referencing source and target column metadata.
* Use **AutoMapping** to automatically identify potential mappings, then review and verify results manually.
* To ignore unwanted columns:
  * With AutoMapping: Disable the respective rows in the mapping table.
  * With Manual Mapping: Enter unwanted column names in the provided fields for both Source and Target.

![Column Mapping](/files/xmxP74ddL4bXBjW2UsJR)

> **Note:** AutoMapping and Data Source Information are supported only for database connectors. For non-database connectors (API, SFTP, S3, ADLS), use manual mapping.

## Step 4: Primary or Composite Key Selection

Define a primary key or composite key for record comparison.

* **Primary Key (Single Column):** Select *Single column*, enter the column name, and press **Enter**.
* **Composite Key (Multiple Columns):** Select *Composite Key*, enter multiple column names separated by commas, and press **Enter**.

![Primary Key Selection](/files/xRK0WxCD9pTyVWQNZTd4)

## Step 5: Save or Run the Job

Choose an execution option:

* **Save** – Saves job configuration for later execution.
* **Save and Start** – Saves and immediately starts the comparison.
* **Quick Run** – Optimized execution for faster processing (supports up to 500,000 records).

![Start Job](/files/HWXujtAnEYz29G0gdRhK)

> **Demo:**
>
> * [DB-to-DB Compare Demo](/data-testing/demo-walkthroughs/index/db-to-db.md)
> * [API-to-File Compare Demo](/data-testing/demo-walkthroughs/index/api-to-file.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.qyrus.com/data-testing/jobs-and-workflows/index/compare-job.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.