Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Configuring a Type 2 Dimension/Version Data Session
Configuring a Type 2 Dimension/Version Data Session
The Type 2 Dimension/Version Data mapping inserts both new and updated rows with a unique primary key. When you configure a session for the mapping, complete the following steps:
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.