Creating a Mapping Using a Dataset FAQS

1. What is a dataset component?

• A dataset component is a container that groups multiple data sources and allows you to join them using relationships. It can include datastores, joins, lookups, filters, and reusable mappings.

2. What can I include in a dataset?

• A dataset can include:
• Datastores (data sources)
• Joins (to link data sources)
• Lookups (to retrieve additional data)
• Filters (to narrow down the data)
• Reusable Mappings (only those with no input signature and one output signature)

3. How do I create a join or lookup in a dataset?

• Drag an attribute from one datastore to another inside the dataset. A dialog will appear, allowing you to choose whether the relationship should be a join or lookup.
• In a join, you link related data between tables.
• In a lookup, you add additional information to the result from the lookup table.

4. What is a driving table and a lookup table?

• The driving table contains the key that is used to look up data.
• The lookup table contains additional data to enrich the result of the join or lookup.

5. How do relationships look in a dataset diagram?

• When you create a join or lookup, an arrow will point from the driving table to the lookup table in the dataset diagram, showing the relationship between the two.

6. What is a flow-based lookup?

• A flow-based lookup occurs in a mapping that is not inside a dataset. The order in which you create connections determines which source is the driver and which is the lookup.
• The first connection is DRIVER_INPUT1.
• The second connection is LOOKUP_INPUT1.

7. How do I create a filter in a dataset?

• To create a filter, drag an attribute from a datastore or reusable mapping onto the background of the dataset. Filters cannot be dragged directly from the component palette into the dataset.

8. Can I use reusable mappings in a dataset?

• Yes, you can use reusable mappings in a dataset, but only those with no input signature and one output signature.

9. Can I drag joins, lookups, or filters from the component palette into the dataset?

• No, joins, lookups, and filters cannot be dragged directly from the component palette into the dataset. You need to create these relationships by dragging attributes between datastores or onto the background for filters.

10. What should I do if I encounter issues with creating joins or lookups?

• Ensure that the relationship you're creating is valid, meaning the keys you're joining or looking up between tables match correctly. Double-check your data sources and the order of connections if you're working with a flow-based lookup.