I have 100 mappings which pull from oracle to oracle
I want to change the IKM on each of those mappings to use another custom IKM
is there an efficient way to change a large group of mappings?
or must it be done 1 by 1 manually via studio (mapping -> physical tab)?
This can be done with ODI SDK.
Check this link:
Script "ODI 12c - Replace KMs in Mappings(UI-Groovy)"