Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference
Appendix B: Configure the Web Browser
- Configure the Web Browser

Designer Guide

10.5
- 10.5.6
- 10.4.1
- 10.4.0

Back Next

Configuring a Slowly Growing Target Session

The slowly growing target mapping flags new source rows, and then inserts them to the target with a new primary key. The mapping uses an Update Strategy transformation to indicate new rows must be inserted. Therefore, when you create a session for the mapping, configure the session as follows:

In the session properties, click the General Options settings on the Properties tab. Set Treat Source Rows As to Data Driven.

In the session properties, click the Target Properties settings on the Mappings tab. To verify that the Integration Service loads rows to the target properly, select Insert for each relational target.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Configuring a Slowly Growing Target Session

Configuring a Slowly Growing Target Session