IKM Notes

• Integration Knowledge Modules (IKM)

• IKM When Staging Area is on the Target Server

• IKM When Staging Area is Different from the Target Server 

• Integration Process 

• Integration Process Overview 

• Append 

• Control Append 

  Incremental Update

• SCD Type 2

• Strategies with the Staging Area Different from the Target 

• Simple Replace or Append 

• Delete Target Table 

• Insert New Rows

• Backup the Target Table Before Loading 

• Drop Backup Table

• Create Backup Table

• Tracking Records for Regulatory Compliance 

• Load Tracking Records