CROSS JOIN

Here’s your content without separator lines:

Integration Process (Simplified)

• An integration process is always required in a mapping.
• It transfers data from source/loading tables → target datastore using a temporary integration table.
• It follows an integration strategy, which defines how data is loaded and updated.

Common Integration Strategies

1. Append

• (Optional) Delete existing records in the target
• Insert all incoming data into the target

2. Control Append

• Same as Append
• Includes optional flow control

3. Incremental Update

• (Optional) Delete existing records
• Compare incoming data with target:
• Insert new records
• Update existing records
• Includes optional flow control

4. Slowly Changing Dimension (Type 2)

• Update changed fields in the target
• Maintain history of previous records for tracking changes

Server Usage

• Single Server: When staging and target are on the same server
• Two Servers: When staging and target are on different servers

If you want, I can make it even shorter for quick revision.