Hi,
In which format do you want to store your tables on HDFS? You could use the Oracle Connector followed by DB Table Selector and DB Reader, then write the result e.g. with a Parquet Writer. You can instruct the writer to write to HDFS by clicking the three dots on the node and choose to add a file system input port, then prepend a HDFS Connector.
Kind regards,
Alexander