dave-csc commented on issue #7257:
URL: https://github.com/apache/hop/issues/7257#issuecomment-4670590932
I'll try to describe the complete process:
1. The first step is a **Table input** from an Oracle database
2. The fields identified as "boolean" (they're actually Integers, since
Oracle doesn't support them) are renamed with an `_INT` postfix via a **Select
values**
3. A **User defined Java Expression** adds the corresponding (Hop) Boolean
fields with the original names, using the following formula: `${bfield} == null
? null : (${bfield}.intValue() != 0)` (`${bfield}` is the name after step 2)
4. Another **Select values** removes the renamed Integer fields, leaving the
actual Boolean counterparts
5. Finally, the data are sent to PostgreSQL via a **Table output**
All of this is implemented via an **ETL Metadata Injection**: the data
injected are the query (step 1), the boolean field names and their integer
aliases (steps 2 and 4), the Java expressions (step 3), and the output table
(step 5).
Hope this helps :)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
