Explore Options for Data Transformation Logic

You can transform data using either lookups or decisions. Learn when to use each option.

Option	Typical usage and guidance	Example
Lookup in an integration	A lookup translates multiple inputs into a certain output. Use a lookup for simple data translation. See About Lookups in Using Integrations in Oracle Integration 3.	Map Code X in System A to Code Y in System B
Decision table in a decision	A decision models data transformations in a decision table and return the same output as a lookup. Use a decision table for more complex logic. See Configure Decision Tables in Using Decisions in Oracle Integration 3.	Calculate a discount percentage. This task could involve iterative steps, inputs, and multiple outputs.

Option

Typical usage and guidance

Example

Lookup in an integration

Integration

A lookup translates multiple inputs into a certain output.

Use a lookup for simple data translation.

See About Lookups in Using Integrations in Oracle Integration 3.

Map

Code X in System A

Code Y in System B

Decision table in a decision

Decision

A decision models data transformations in a decision table and return the same output as a lookup.

Use a decision table for more complex logic.

See Configure Decision Tables in Using Decisions in Oracle Integration 3.

Calculate a discount percentage. This task could involve iterative steps, inputs, and multiple outputs.