Joiner

The Joiner Transformation is used to combine data from multiple sources or datasets based on a common key or field. Its primary applications include:

  1. Data Integration: Merges data from different sources into a unified dataset based on shared fields or relationships.
  2. Combining Datasets: Combines two or more datasets, enriching the data by including fields from each dataset.
  3. Creating Relationships: Establishes connections between related datasets, allowing for more comprehensive analysis.
  4. Multi-Dataset Processing: Enables the processing of data across different datasets, improving data completeness and context.
  5. Flexible Joins: Supports different types of joins (inner, left, right, full) to control how data from multiple sources is combined.

This transformation is crucial for scenarios where data from different systems, tables, or files need to be consolidated into a single dataset for further analysis or reporting.

Joiner Object

Properties

To change the Joiner properties double click on the object.

Joiner Object Properties

Joiner Object Output Fields

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on January 15, 2025 • 1 min read • 199 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License