Union Streams Step
Merges input formats of two defined inputs into a single output format (horizontal merge).
Data is read from the individual inputs (in_a or in_b) and written to the output.
| 
 This step is available for standalone plans, embedded plans, and transformation catalog items.  | 
Therefore, in the output there are merged-format data records, where each row contains data read from either in_a or in_b input.
Configuration
- 
From other steps, create a connection to
in_aandin_b, as required. - 
Select Add Union mapping and specify:
- 
Destination: Destination column name.
 - 
In a: Data to be input from
in_a. - 
In b: Data to be input from
in_b. 
 - 
 - 
Repeat as necessary.
 
Was this page useful?