Dear community and Database experts,
in ONE DATA we have the possibility to write data to an existing table on the database. In my case this would be an Oracle-DB.
Usecase
We have a quite large table in ONE DATA: roughly 10 billion rows with 5 columns (double and string). We want to write this table to the Oracle database, such that other users can use this table for their analysis.
Question
- Is it possible to store a compressed table on the Oracle DB from within ONE DATA?
- Is there a built-in functionality or would I need to create a compressed table first and then append into that one?
- Does this table-compression only help to reduce the storage-amount on the database or will also the amount of data transferred from ONE DATA to Oracle via JDBC reduced?#
Thank you for your help!