topic Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration in Talend Studio

[resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Sat, 16 Nov 2024 13:37:29 GMT

Hi,
Language: Java
Database used: Postgres 8.4 / Oracle 10g
I am trying to use tMap component to transform data from boolean type in Postgres to NUM in Oracle (e.g. if column has value false then insert 0)
This is needed as part of Data migration exercise. Some how I did not find way how to do it. I looked through component tConvertType but that does not seem to be helpful either.
Any help on how to achieve this?
Thanks,
Mahendra

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Wed, 06 Jan 2010 09:28:46 GMT

Hello Mahendra
Try the following expression on tMap: eg:
tPostgresInput--row1--tMap--tOracleOutput

row1.columnName==false?0:1

Best regards

shong

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Wed, 06 Jan 2010 09:46:06 GMT

Hi Shong,
I tried the option suggested by you, but this does not work. I have uploaded the screen shot of the same.
The error message coming up after clicking "Test!" button is
"Type mismatch: cannot convert from int to BigDecimal"
Thanks,
Mahendra

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Wed, 06 Jan 2010 10:25:07 GMT

Hello
If the data type of output column is BigDecimal, try

row1.columnName==false?new BigDecimal(0) :new BigDecimal(1)

Best regards

shong

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Wed, 06 Jan 2010 10:42:20 GMT

Thanks Shong,
this works.
However I am still getting the message "Exception in thread "main" java.lang.Error: Unresolved compilation problems: ".

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Wed, 06 Jan 2010 14:16:20 GMT

Hello

However I am still getting the message "Exception in thread "main" java.lang.Error: Unresolved compilation problems: ".

Does it show the message when you click on 'Test' button? Don't worry, just forget it and I suggest you not to use 'Test' button, it always confuse user eventhough there are not compilation problems in the generated code.
Best regards
shong

Re: [resolved] Data transformation (Postgres boolean -> Oracle NUM) - Migration

Anonymous — Tue, 25 Nov 2014 20:38:32 GMT

Try this using tMap.. row2.Hidden.compareTo(row2.Hidden)