topic Oracle string to Postgres Boolean conversion in Qlik Replicate

Oracle string to Postgres Boolean conversion

vchilakamarthi — Tue, 09 Apr 2024 17:33:28 GMT

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.

Re: Oracle string to Postgres Boolean conversion

vchilakamarthi — Tue, 09 Apr 2024 18:30:15 GMT

I found this is working for me in expression builder.

CASE

WHEN option = 'Y' THEN true

WHEN option = 'N' THEN false

ELSE false

END

Re: Oracle string to Postgres Boolean conversion

john_wang — Wed, 10 Apr 2024 00:13:26 GMT

Thank you for your great support! @vchilakamarthi