How to bring values of all column in BEFORE IMAGE record of __CT table

[ashankaralingam]

I have an use case where I am in need of knowing the values of all column in before image, since I'm using only store change task.  How to make the UPDATE record or BEFORE IMAGE operation to hold all column value irrespective of the changes happened or not.

[DesmondWOO]

Hi @ashankaralingam ,

Thank you for creating a new post! Regarding your question, could you clarify which source database are you using?

Regards,
Desmond

[ashankaralingam]

Source is Oracle Database and destination is snowflake.

[DesmondWOO]

Hi @ashankaralingam ,

Please add supplemental logging on all columns. Details can be found in this article.

Regards,
Desmond

[ashankaralingam]

Thanks @DesmondWOO  I will check this option and let this group know. I hope this will work. Thanks for your support.