SCD2 (version number) - I need my ancestors!

To implement SCD2 using wizard, follow these steps:

  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 of the new SCD mapping (m_SCD2_VERSION_NUMBER). Also, select the Type of SCD you wish to implement. Select Type 2 Dimension - keep a full history of the changes in the target as we are implementing SCD2 using version number. Click on Next:
  1. The next screen will ask you ...

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