MSAMM
Back to course

Oracle Integration Cloud: Building Integrations That Survive Production · Module 5 · Mappings and transformations

What breaks: five mapping failures

Lesson 57 of 175 · 2 min

Five mapping failures, and not one of them produces an error. ONE: AN OPTIONAL FIELD LEFT UNMAPPED. The target defaults it and the record is created carrying a value nobody chose. A successful run, a wrong record, and it is wrong on every record the integration ever creates. Lesson 3. TWO: A LOOP THAT EMITTED ONE ROW. Forty lines in, one line out. The invoice exists and is short, and the totals are wrong by an amount nobody notices until a reconciliation. Lesson 4. THREE: A DATE SHIFTED BY A ZONE. Right for most of the year, a day out for the rest. The tell is a defect that appears in spring and vanishes in autumn, which is why it is misdiagnosed. Lesson 7. FOUR: A ROUNDED AMOUNT. Or truncated, or scaled, or read as the wrong monetary unit. Invisible per record and material per month, and the hundred-times version

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Integration Cloud: Building Integrations That Survive Production, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 5 · Mappings and transformations

  1. 1What a mapping really isFree preview
  2. 2The mapper, practically
  3. 3Required, optional and the empty element
  4. 4Repeating elements and loops
  5. 5Conditional mapping
  6. 6Functions: strings, numbers and dates
  7. 7Dates and time zones, carefully
  8. 8Numbers, precision and currency
  9. 9Lookups inside a mapping
  10. 10Testing a mapping with real data
  11. 11Namespaces, and the errors they cause
  12. 12Keeping a mapping maintainable
  13. 13What breaks: five mapping failures
  14. 14Lab briefing · Map two schemas that disagree