Differences Between Flow and Dataset Modeling FAQS

1. What is a dataset in ODI?

• A dataset is a container component in ODI that holds one or more source datastores, which are related using relationships such as filters and joins. It behaves similarly to a projector component in a mapping and represents the results of these relationships on its output port.

2. How is data related inside a dataset?

• Data sources within a dataset are related using relationships (e.g., joins and filters) rather than a flow. These relationships are visually represented in an entity relationship diagram.

3. How does dataset modeling differ from flow modeling?

• Dataset modeling uses relationships to link data sources (as seen in ODI 11g), while flow modeling in ODI 12c uses a flow-based metaphor where data sources are connected in a sequence. The physical flow in the mapping editor behaves the same regardless of whether you're using datasets or flow.

4. What happens when I switch to the physical tab in the mapping editor?

• When you switch to the physical tab, datasets disappear. ODI models the physical flow of data as if a flow diagram had been defined in the logical tab, treating datasets and flows in the same way.

5. Why am I prompted to include an empty dataset when creating a new mapping?

• When creating a new mapping, you can choose to include an empty dataset for convenience. This is an optional step, and the dataset can be deleted or added later without affecting your mapping.

6. Can I design a dataset as a separate object outside of a mapping?

• No, datasets can only exist within a mapping or reusable mapping. They cannot be independently designed or used as separate objects outside of this context.

7. What happens if I import projects from ODI 11g into ODI 12c?

• When you import projects from ODI 11g, interfaces converted into mappings will contain datasets that group the source datastores, as ODI 11g used datasets for organizing data sources.

8. Can I delete an empty dataset after creating a new mapping?

• Yes, you can delete the empty dataset without any issues. It's simply an optional component that can be removed if not needed.

9. Are datasets and flows interchangeable?

• No, datasets and flows are not interchangeable. Datasets organize data sources using relationships like joins and filters, whereas flows organize data in a continuous sequence. However, in the physical tab, ODI models both types of relationships similarly.

10. What is the main advantage of using a dataset over a flow?

• The primary advantage of using a dataset is that it follows the traditional ODI 11g approach for organizing data sources using relationships, making it easier to work with projects imported from older ODI versions or when using a more structured, relational approach.