O'Reilly logo

Implementing Oracle Integration Cloud Service by Phil Wilkins, Robert van Mölken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Incorporating a lookup into a mapping

So, let's start editing the lookup; in the Integration view, click on FlightStatusEnquiry_Ch6_2 so we can start to edit it. Open up the target to source mapping view and we are going to add a mapping to the simpleNote element that takes the suffix that we are going to use to represent the two-letter IATA airline code and retrieves the airline's full name. So, select simpleNote field on the right side of the mapping, which will take us to the Build Mapping view. On the left side of the panel, select Mapping Components, and then open up the folder tree beneath it so the tree reveals Functions | ICS and the lookupValue option with in. You should see part of the Build Mappings screen shown as follows.

Select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required