dear all,
Have requirement to decrypt one of columns in source while cdc/init extract. key can't be shared outside of source, so have to decrypt one of columns data in a table while extracting from source and encrypt again with own key which can be shared and decrypt encrypted replicat data at target in reporting obiee.
pls throw your inputs on how to achieve this in goldengate.