Creating a Mapping

1. Start the Mapping Creation Process:
• Open the Mapping Editor by either opening an existing mapping or creating a new mapping as described previously.
• If creating a new mapping, right-click the Mappings node under your project and select New Mapping.
2. Define the Logical Diagram:
• Use the logical diagram of the Mapping Editor to begin constructing your mapping.
• Drag components (such as datastores, transformations, filters) from the Component Palette into the diagram.
• Create connections between the components by dragging lines between them to define the data flow.
3. Connect Attributes:
• Drag attributes across the connections between components to define how data will flow between them.
• These connections will represent how the data will be transferred, transformed, or filtered through the mapping process.
4. Modify Component Properties:
• Use the Property Inspector to modify the properties of the selected components.
• The Property Inspector allows you to configure the settings for each component, such as transformation rules, data types, or connection details.
5. Define the Physical Diagram:
• Once the logical design is complete, switch to the physical diagram to define the physical aspects of the integration process.
• In the physical diagram, you will specify how and where the integration process will run on your physical infrastructure (e.g., which servers, databases, or other systems will be involved).
6. Finalizing the Mapping Design:
• After completing both the logical and physical designs, review your mapping to ensure that all components are connected properly and that the properties are configured correctly.
7. Run the Mapping:
• Once your logical and physical design is complete, you can run the mapping to execute the data integration process.
• Running the mapping will trigger the transformation and loading of data according to the design you have created.