Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to set up replication from Oracle DB as source to Postgresql DB as target for one table.
There is one column that is varchar2 on source(oracle) that I have to convert to boolean on target (postgres).
Can that be done using expression builder. If so is there any reference that you can point me to.
Thank you.
I found this is working for me in expression builder.
CASE
WHEN option = 'Y' THEN true
WHEN option = 'N' THEN false
ELSE false
END
Thank you for your great support! @vchilakamarthi
I found this is working for me in expression builder.
CASE
WHEN option = 'Y' THEN true
WHEN option = 'N' THEN false
ELSE false
END
Thank you for your great support! @vchilakamarthi