Operator | Supported |
Renaming | Yes. Example: C1 AS C2 |
Projection | Yes, for creating a view from two table columns with scalar function support. Example: SELECT UPPER(C1) |
Selection | Yes, with scalar function support. Example: WHERE LOWER(C1) = ‘abc’ |
Inner Join | Yes. |
Left Outer Join | Yes, if only the left side is monitored by GoldenGate. Otherwise, no. The restriction applies because processing of the data change for left outer joins could result in inaccurate data. |
Right Outer Join | Yes, if only the right operand is monitored by GoldenGate. Otherwise, no. The restriction applies because processing of the data change for right outer joins could result in inaccurate data. |