Union All Object

The Union All Transformation is used to combine multiple datasets or data streams into a single dataset by appending rows from each dataset. Its primary applications include:

1. Combining Data: Merges multiple datasets, stacking their rows on top of each other to create a unified dataset.
2. Data Consolidation: Aggregates data from different sources or stages of processing, ensuring no data is lost.
3. Handling Identical Structures: Typically used when the datasets have the same structure (i.e., the same columns), ensuring that all rows are included in the result.
4. Efficient Merging: Unlike a standard UNION, Union All does not remove duplicate rows, making it useful when all records, including duplicates, are necessary for analysis or further processing.
5. Data Preparation: Prepares data by combining it from multiple origins into one dataset for easier downstream operations, such as reporting or analysis.

This transformation is ideal for scenarios where you need to bring together data from different sources or stages without excluding any rows.

Properties

To change Union All Transformation properties double click on the object.