You have not given the snapshot of the columns showing their SCD behavior (surrogate key, natural key, add row on change, update on change, ...).
Have you set the SCD behavior for all the columns for the Target datastore?
I did have set the SCD behaviour for all the columns - will upload the screen print when I get back to my work laptop. Thanks for looking into this.
Sure. I have been using ODI 12.1.2 for some months for loading dimensions, but haven't faced any issue yet.
What is the version you are using, is it 12.1.2 or 12.1.3?
May I request you to try something?
Please change the IKM from SCD to simple Control Append and execute this Mapping. This is just to make sure that the error comes from using the SCD KM
If it doesn't fail in Control Append, then also upload:
- snapshot of the physical flow
- snapshot of the operator (steps which are generated and error step)
I see that you have deleted the default source area, but I don't think that the error is related to it.
This error has something to do with ODI not being able to relate the 3 mapped columns and the source table with the staging area (I$).