Oracle string to Postgres Boolean conversion

[vchilakamarthi]

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.

[vchilakamarthi · Accepted solution]

I found this is working for me in expression builder.

CASE

WHEN option = 'Y' THEN true

WHEN option = 'N' THEN false

ELSE false 

END

[john_wang · Accepted solution]

Thank you for your great support! @vchilakamarthi