how to export records of each day from Oracle table to csv

Four Stars

how to export records of each day from Oracle table to csv

Hi every one,


i have a Oracle table which has now 100.000 records. every day it has more than 1000 new records.

i want to create a Talend Job which can export records on each day to csv.

The records have the same Date will be exported to a csv.


For example:

Name          Date         Sale

A              01.01.2018    500

B              01.01.2018    600

C             02.01.2018     699


in this example, there are 2 different Date: 01.01.2018 and 02.01.2018, therefore the Table will be exported into 2 csv Data


Can you please help me with this?






Re: how to export records of each day from Oracle table to csv



    Please pass the date as parameter value to tOracleinput and extract the data. The same value can be appended to the file name of csv file. In this way, you can fetch data for each date and pass them as separate files.


   Please note that you will have to loop each date value as a parameter to tOracleinput if you are having multiple dates. In this case, please add an additional tflowtoIterate component.


Warm Regards,


Nikhil Thampi


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Creating a Stewardship Campaign and Data Model

In this video, you will see how to create a new campaign and enable team members to address curation tasks assigned to them within an approval workflow process

Watch Now

Managing a Stewardship Campaign

In this video, you will see how to assign your best team members specific tasks to reconcile, correct, merge, arbitrate or group pre-determined data and achieve quality, clean data in a limited time

Watch Now

Talend Data Stewardship – What does it have to offer?

In this short series, you will see how Talend Data Stewardship transforms your employees into data citizens and enables them with self-service capabilities to control their quality data

Watch Now