I'm using dynamic schema and loading data from Oracle to CSV file.
But in oracle date format is "dd-MM-yyyy hh:mm:ss" but I need "yyyy-MM-dd" in my csv output. I've given the expected dat pattern in dynamic schema as well but its not working.
May I know how date pattern can be changed using dynamic schema ? If not what's a purpose of date pattern in dynamic schema...?
@kate,have you checked below link?
short answer : getting control on field/columns using dynamic data type is not possible during load. So the answer is NO.
But you can achieve this using ELT techniques , after load.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.