Adding and Removing Components

Adding Components to the Mapping

1.     Open the Mapping Editor:

• Ensure you have the mapping open in the Mapping Editor.

2.     Drag Components from the Component Palette:

• In the Component Palette, drag and drop components (e.g., transformations, filters, operations) into the logical diagram.
• These components will represent the operations or transformations applied to your data during the integration process.

3.     Drag Datastores and Reusable Mappings from the Designer Navigator:

• You can also drag datastores (both source and target) and reusable mappings from the Designer Navigator into the mapping diagram.
• These will be used to define your data sources and targets, as well as any reusable data flow logic.

Removing Components from the Mapping

1.     Select the Component to Delete:

• Click on the component in the logical diagram that you wish to delete.

2.     Delete the Component:

• Press the Delete key on your keyboard, or
• Right-click the selected component and choose Delete from the context menu.

3.     Confirm Deletion:

• A confirmation dialog will appear asking you to confirm that you want to delete the component. Click Yes to confirm.

Understanding Source and Target Datastores

1.     Source Datastores:

• The source datastores are where the data originates from. These are the input sources for the mapping.
• Data is extracted from these datastores during the mapping process.

2.     Target Datastores:

• The target datastores are where the processed data will be loaded. These are the output targets for the mapping.
• Data will be loaded into these datastores after it has passed through the necessary components and transformations.

3.     Components Between Source and Target:

• Between the source and target datastores, you can place various other components like transformations, filters, joins, or lookups that manipulate the data as it flows from the source to the target.

4.     Data Flow:

• When the mapping is run, data will flow from the source datastores, pass through the components you have defined, and finally be loaded into the target datastores.