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.
The Type 3 Dimension mapping inserts new rows and updates existing rows in the target. When you configure a session, complete the following steps:
Click the General Options settings on the Properties tab. Set Treat Source Rows As to Data Driven.
Click the Target Properties settings on the Mappings tab. To verify that the Integration Service loads rows to the target properly, select Insert and Update as Update for each relational target.