Mapping: Implement SQL Minus Operation
Posted by: Bharath B S
An Informatica PowerCenter mapping to demonstrate how to implement SQL minus set operation using a joiner transformation.
Overview
Overview:Set operators are used to join the results of two (or more) SELECT statements. The SET operators available in Oracle 11g are UNION, UNION ALL, INTERSECT and MINUS. Minus operator displays the rows which are present in the first query, but absent in the second query, with no duplicates and data arranged in ascending order by default. Source: EMP_A
EMP_B
Target
| EMP_ID | EMP_NAME |
|---|---|
| 1 | Scott |
| 1 | Scott |
| 2 | Matt |
| 2 | Matt |
| 3 | Chris |
| EMP_ID | EMP_NAME |
|---|---|
| 2 | Matt |
| 2 | Matt |
| EMP_ID | EMP_NAME |
|---|---|
| 1 | Scott |
| 3 | Chris |
Features
System Requirements
- Informatica PowerCenter 9.1.0 and above.
