Oracle Golden Gate Cloud Service Workshop Ed2 — Lesson 3: Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication

Learning Objectives

• Translate a realistic requirement into an executable approach for Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication.
• Use transformation test and reconciliation output to verify completeness, access, and process behaviour.
• Explain how to recover safely when column mapping truncating data in the target occurs.

Detailed Topics

• Filtering
• Mapping
• Transformations
• Conflict handling
• Scaling
• And heterogeneous replication
• Decision ownership, prerequisites, and acceptance evidence for Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication
• Relevant access, data, integration, performance, recovery, and support considerations

Instructor Demonstration

The instructor builds a representative scenario for Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication, narrating each decision and showing how it contributes to a secure GoldenGate Cloud deployment that captures, transports, applies, monitors, and recovers replicated data reliably. The demonstration records transformation test and reconciliation output so learners can compare configuration intent with observable behaviour.

Hands-On Exercise

Configure and test Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication with representative records. Use “column mapping truncating data in the target” as the troubleshooting challenge, compare competing hypotheses, retest only the affected path, and complete transformation test and reconciliation output for peer review.

1. Define the requirement and identify dependencies before changing the environment.
2. Create a baseline result that can be compared with later changes.
3. Reproduce the exception and test one hypothesis at a time.
4. Complete the evidence record and obtain peer or instructor review.

Scenario Analysis

• Clarify the business trigger, affected roles, required records, and acceptable result for Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication.
• Compare at least two implementation or correction choices and identify which evidence would distinguish them.
• Decide how transformation test and reconciliation output should be reviewed, approved, retained, and handed to the next owner.

Troubleshooting Guidance

Avoid editing multiple settings at once when troubleshooting Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication. Preserve the failing example, review transformation test and reconciliation output, and verify whether “column mapping truncating data in the target” is the root cause. After remediation, repeat the transaction, confirm downstream effects, and record any monitoring action.

Validation Checklist

• The scope of Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication is clear, including what is deliberately excluded from the test.
• Evidence in transformation test and reconciliation output supports each material decision and outcome.
• A negative test demonstrates that controls reject or flag an invalid condition.
• Open risks, owners, due actions, and production safeguards are documented.

Lesson Outcome

Learners can apply Filtering, mapping, transformations, conflict handling, scaling, and heterogeneous replication, explain the decisions made, and defend the result with transformation test and reconciliation output.