SCD2 (version number) – I need my ancestors!

To implement SCD2 using the wizard, perform the following steps:

  1. In the Designer, navigate to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions, as shown in the following screenshot:
    SCD2 (version number) – I need my ancestors!

    A new window will pop up, asking you 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 a version number. Click on Next.

    SCD2 (version number) – I need my ancestors!
  2. The next screen ...

Get Learning Informatica PowerCenter 9.x now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.