You can translate the question and the replies:

Write the retrieved data into multiple files

Hello, Need to retrive the data from Oracle database, it may have millions for records, I need to write the data in to muliteple CSV files(split the data in to mulitple files). I was able to read the data and write it as single files using schedule admin by creating a job and made configuration in Exporter section. Is there a way , I can split the retrived data and write in to multiple CSV files. Thanks, Senthil.
user
03-05-2020 22:26:25 -0400

1 Answer

Hi, To export data into multiple CSV files, I would create a Scheduler job that queries Virtual DataPort based where condition and then exports it to a CSV file by doing this we can split up data and store data into CSV file. For example, I have a bv_student base view in Virtual DataPort, I need to export the data based on department CSE and IT, need to store in the two different CSV files. To achieve that, I would either create two VDP jobs or modify the existing job where condition in the query similar as below, Initially create a VDP job in Scheduler and then configuring an Extractor below query, and writing it to a CSV requires an Exporter. `select * from bv_student where department='CSE'` After executing the job with the above query, then modify the where condition as department='IT' and then execute the job again. By doing this, I was able to get the data in the two different CSV files. If you have more questions and a user with a valid support access account,then I would suggest you raise a support case in the [Denodo Support Site](https://support.denodo.com/) with more detailed information. Hope this helps!
Denodo Team
04-05-2020 05:23:54 -0400
You must sign in to add an answer. If you do not have an account, you can register here