Integration Process

1. Purpose of Integration Process:
• The integration process is a crucial step in data mapping.
• It integrates data from the source or loading tables into the target datastore.
• A temporary integration table is used during this process.
2. Integration Strategy:
• An integration strategy defines the steps involved in the integration process.
3. Examples of Integration Strategies:
• Append:
• Optionally deletes all records in the target datastore.
• Inserts all the flow into the target.
• Control Append:
• Optionally deletes all records in the target datastore.
• Inserts all the flow into the target.
• Includes an optional flow control to manage the process.
• Incremental Update:
• Optionally deletes all records in the target datastore.
• Identifies new and existing records by comparing the flow with the target.
• Inserts new records and updates existing records in the target.
• Includes an optional flow control for better management.
• Slowly Changing Dimension (SCD):
• Implements a Type 2 Slowly Changing Dimension (SCD).
• Identifies fields that require simple updates in the target record.
• Histories the previous record state when necessary for change management.
4. Server Configuration:
• The integration process may involve:
• A single server if the staging area and target are located in the same data server.
• Two servers if the staging area and target are on different servers.