- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Configuring a slowly changing dimension
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.