Integration Process in odi

Integration Process

An integration process is always needed in an interface. This process integrates data from the source or loading tables into the target datastore, using a temporary integration table.
An integration process uses an integration strategy which defines the steps required in the integration process. Example of integration strategies are:

• Append: Optionally delete all records in the target datastore and insert all the flow into the target.
  
• Control Append: Optionally delete all records in the target datastore and insert all the flow into the target. This strategy includes an optional flow control.
  
• Incremental Update: Optionally delete all records in the target datastore. Identify new and existing records by comparing the flow with the target, then insert new records and update existing records in the target. This strategy includes an optional flow control.
  
• Slowly Changing Dimension: Implement a Type 2 Slowly Changing Dimension, identifying fields that require a simple update in the target record when change, fields that require to historize the previous record state.