Creating Multiple Targets FAQS

1. How do I create multiple targets in a mapping?

• A datastore with inputs but no outputs in the logical diagram is considered a target. You can insert multiple target datastores in a mapping by connecting the output of a component to multiple downstream components. This creates multiple targets within a single mapping.

2. What is a target datastore in ODI 12c?

• A target datastore is a component that has inputs but no outputs in the logical diagram. It receives data from other components in the mapping.

3. Can I split the output of a component into multiple flows?

• Yes, ODI allows you to split a component’s output into multiple flows at any point in the mapping. This enables routing data to multiple targets within a single mapping.

4. What happens when I connect the output to multiple downstream components?

• When the output of a component is connected to multiple downstream components, all rows of the component’s result will be processed in each downstream flow.

5. How can I conditionally process data in the downstream flows?

• You can use a split component to define split conditions that route the data to different downstream flows based on specific conditions, allowing for conditional processing.

6. Do I need separate mappings for multiple targets?

• No, ODI allows you to create a single mapping with multiple independent flows to avoid the need for creating separate mappings. This eliminates the need for a package to coordinate multiple mappings.

7. What is the purpose of the split component?

• The split component is used to define conditions for routing or processing data differently in downstream flows. It enables conditional data processing when you need to split the flow based on specific criteria.

8. Can I create multiple targets in a mapping without a split component?

• Yes, you can connect the output of a component directly to multiple downstream components. However, if you need to apply specific conditions to each flow, you should use a split component.

9. Is it necessary to have a package to coordinate mappings with multiple targets?

• No, ODI allows you to create a single mapping with multiple independent flows. This approach eliminates the need for a package to manage multiple mappings.

10. Can I process the same data in multiple targets simultaneously?

• Yes, all rows from the component’s output are processed in each downstream flow. This means the same data can be processed simultaneously in multiple targets, allowing for parallel processing of data.