Creating a Mapping Using a Dataset

1. Understand the Dataset Component:
• A dataset component is used to group multiple data sources and join them via relationship joins.
• It can contain the following components:
• Datastores
• Joins
• Lookups
• Filters
• Reusable Mappings (only mappings with no input signature and one output signature are allowed).
2. Create Joins and Lookups:
• Drag an attribute from one datastore to another inside the dataset.
• A dialog will appear asking whether the relationship should be a join or lookup.
• Driving Table: Contains the key to look up.
• Lookup Table: Contains additional information to be added to the result.
• An arrow will be drawn from the driving table to the lookup table in the diagram.
3. Flow-based Lookup (for mappings not inside a dataset):
• For flow-based lookups, the order of connections determines the sources:
• The first connection is the DRIVER_INPUT1.
• The second connection is the LOOKUP_INPUT1.
4. Create Filters:
• Drag an attribute from a datastore or reusable mapping onto the background of the dataset to create a filter.
• Note that joins, lookups, and filters cannot be dragged from the component palette into the dataset.