Creating a Dataset in a Mapping FAQS

1. How do I create a dataset in a mapping?

• To create a dataset in a mapping, drag a dataset from the component palette into the logical diagram. Then, drag datastores from the Models section of the Designer Navigator into the dataset.

2. Where do I get the datastores for my dataset?

• Datastores are available in the Models section of the Designer Navigator. You can drag them into your dataset from there.

3. How do I define relationships between datastores in a dataset?

• To define relationships (like joins and lookups) between datastores within a dataset, drag attributes from one datastore to another. This action will create the relationships.

4. Can I create joins and lookups in a dataset?

• Yes, you can create joins and lookups by dragging attributes between datastores within the dataset. This will define the relationships between them.

5. How do I connect a dataset to other components in the mapping?

• To connect a dataset to other components, drag a connection from the dataset's output connector point to the input connector point of other components in your mapping. This integrates the dataset into the data flow.

6. Can I add multiple datastores to a single dataset?

• Yes, you can add multiple datastores to a single dataset. Each datastore can then be linked using joins and lookups.

7. Do I need to manually specify relationships between all datastores in the dataset?

• You need to manually define relationships by dragging attributes between datastores. ODI will not automatically create these relationships for you.

8. What is the role of the output connector in a dataset?

• The output connector of the dataset represents the result of the relationships (joins, lookups) defined inside the dataset. You will connect this to other components in the mapping to include the dataset’s output in the data flow.

9. Can I delete a dataset once it’s added to a mapping?

• Yes, you can delete a dataset from the mapping if you no longer need it. Deleting it will not affect other parts of the mapping, as long as no connections depend on it.

10. Is there a limit to how many datastores I can add to a dataset?

• There is no strict limit to how many datastores you can add to a dataset, but the more datastores you include, the more complex the relationships and performance considerations may become.