Creating Multiple Targets

1. Identify the Target Datastore:
• In Oracle Data Integrator, any datastore component that has inputs but no outputs in the logical diagram is considered a target.
2. Insert the Datastore as a Target:
• Drag the datastore into the mapping.
• Ensure the datastore has no outgoing connections (it will only have incoming connections), indicating it is a target.
3. Split Output into Multiple Flows:
• ODI allows you to split a component’s output into multiple flows within the mapping. This allows for multiple targets within a single mapping.
4. Connect Output to Multiple Downstream Components:
• The output port of many components can be connected to multiple downstream components. This will result in each row of the component's result being processed in all the downstream flows.
5. Conditionally Route Rows (Optional):
• If rows need to be routed or processed conditionally in the downstream flows, consider using a split component.
• The split component allows you to define specific conditions for routing the data to different flows.
6. Avoid Using Packages for Multiple Mappings:
• By creating a single mapping with multiple independent flows, you can avoid the need to create separate mappings and coordinate them through a package.