MSAMM
Back to course

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

The mapper, practically

Lesson 46 of 175 · 2 min

The mechanics quickly, so the rest of this module can be about correctness. DRAGGING covers the majority: source element to target element, one to one. Most of a real mapping is exactly that, and the interesting parts are the few that are not. THE EXPRESSION BUILDER is for everything else — concatenation, a condition, a function, a lookup. Build expressions in small pieces and test as you go; a long expression assembled in one go and then debugged is the slowest way to work in this tool. READING A MAPPING SOMEBODY ELSE WROTE is the skill this lesson is really about, because you will do it more often than you write one from scratch. Read it TARGET-FIRST, top to bottom, the same order it was designed in. For each element ask: is it mapped, and from where? The unmapped ones are what you are looking for — they are invisible

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