SCD2 (date range) - marking the dates

To implement SCD2 by maintaining a flag, 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_SCD2_DATE_RANGE) of the new SCD mapping. Select Type 2 Dimension - keep a full history of the changesas we are implementing SCD2, and click on Next:
  1. The next screen will ask you to select the source. Select a source from the drop-down. We are using EMP_FILE.txt as ...

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