Configuring a slowly changing dimension

3673816

Hello Forum.

Does anybody know why when I configure a mapping with a target table being a SCD2 type, when I go to the "Physical" tab and click on the target table icon in the diagram, the Integration Knowledge Module drop-down in the Properties section lists only the default IKM modules, like IKM Oracle Insert.Global, but not IKM Oracle Slowly Changing Dimension, even though I do have the latter imported into the Knowledge Modules node of the designer tree under the project where the mapping needing it exists?

I am pretty sure I need the "IKM Oracle Slowly Changing Dimension".

I am trying to follow video https://www.youtube.com/watch?v=FzzBbWtMXFg 

Starting at frame 8:40, he talks about the confirm a bit, but it's based on an older version ODI, so the UI looks a little different.

Thank you

Boris

Adrian_Popescu-Oracle

Hi Boris,

Check this tutorial:

Building an SCD2 Mapping in ODI 12c v12.2.2.1 - Red Stack Tech

You have to setup SCD at the level of target datastore.

Adrian

Adrian_Popescu-Oracle

Hi Boris,

Check this tutorial:

Building an SCD2 Mapping in ODI 12c v12.2.2.1 - Red Stack Tech

You have to setup SCD at the level of target datastore.

Adrian

Pavan8u

Hi Boris,

In the logical tab of mapping click on target data store, goto properties->Target->Integration Type and select Slowly Changing dimension.

Now go to physical tab, there you will be able to see SCD related IKMs.

As mentioned by @Adrian_Popescu-Oracle you have to setup SCD properties like add row on change, start time stamp etc at datastore level.

Hope this helps.

Regards,

Pavan

3673816

Thank you Adrian and Pavan for your helpful response.

Much appreciated.

Boris