Set Operations (DB)
Combines results from merging two or more queries into a single result set.
Information at a Glance
Note: You can also use this operator in a workflow that uses TIBCO® Data Virtualization and Apache Spark 3.2 or later.
Parameter |
Description |
---|---|
Category | Transform |
Data source type | DB |
Send output to other operators | Yes |
Data processing tool | n/a |
Note: The Set Operations (DB) operator is for database data only. For Hadoop data, use the
Set Operations (HD) operator.
Input
Two or more databases.
Restrictions
- The number and the order of the columns must be the same in all queries.
- The data types must be compatible.
Configuration
Parameter | Description |
---|---|
Notes | Notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk appears on the operator. |
Sets | Click Define Sets to display the Define Sets dialog. For more information, see the Define Sets dialog. |
Output Type |
|
Output Schema | The schema for the output table or view. |
Output Table | Specify the table path and name where the output of the results is generated. By default, this is a unique table name based on your user ID, workflow ID, and operator. |
Storage Parameters | Advanced database settings for the operator output. Available only for
TABLE output.
See Storage Parameters dialog for more information. |
Drop If Exists | Specifies whether to overwrite an existing table.
|
Output
Visual Output
The data rows of the output table or view displayed (up to 200 rows).
Data Output
A data set of the output table or view of the joined data sets. This operator always creates a CSV output.