SCD1 - I hate history!

To implement SCD1 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 (m_SCD1) of the new SCD mapping. Select Type 1 Dimension - Keep most recent values in the target as we are implementing SCD1. Click on Next:

  1. The next screen will ask you to select the source. Select a source from the drop-down. All the sources present in your repository will be listed in this ...

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