SCD3 - store something if not everything

To implement SCD3 using wizard, please follow the steps mentioned here:

  1. In the Designer, go to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions as shown in the following screenshot:

  1. A new window will pop up asking the name (m_SCD3) of the new SCD mapping. Also select the type of SCD you wish to implement. Select Type 3 Dimension - keep the current and previous value in the target as we are implementing SCD3, and click on Next:
  1. The next screen will ask you to select the source. ...

Get Learning Informatica PowerCenter 10.x - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial